First time camping - tent leaked, kid got soaked, still a win?

Took my 6yo camping for literally the first time ever last weekend. Got a brand new Coleman tent from Walmart (like $70). First night it rains. Not a little bit - actually rains.

Woke up to water pooling under his sleeping bag. Spent the rest of the night in the car. Pretty sure I failed camping 101 lol.

BUT - he wants to go again, I learned I need a better tent and probably a tarp situation, and honestly the car sleeping wasn't even that bad? We still did a campfire, made s'mores, and he caught a frog. Calling it a win and trying again next month with an actual good tent.