
The North Face
Wawona 6
Spacious vestibule, strong in storms, but rainfly tricky solo.
Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
Annoyingly, they are holding back on the useful spec. Which might be concerning. Anyway. For its price, it's a great starter tent. We all start with a starter tent, learn what it lacks and then upgrade at some point. It's not designed for storms, and most people are not like me and purposefully camp during a storm. If I were you, I'd buy it. Hey, when you have your first camp, post pictures and I hope you have an amazing time.
You won’t get “totally wet” The fly does a great job of sloughed the main water onto the sides, and the rest of the fabric is waterproof anyways. Seams have held for me in downpours, and the bottom is tarp so you won’t get wet through it. Just make sure like always that you don’t have sleeping bags touching the inside walls and you’ll stay dry!
I'm sorry that you were let down! I have had great luck with Colemans. High end companies need full flys because they have more mesh to be lighter, and they are able to withstand harsher conditions longer. No, I wouldn't take this tent backpacking for weeks on end. But it does the job on overnights.
I haven't ran into this problem with the 2-person model.
I wanted to add that, as the kids get older, you/they may want more space. We're a family of 5. We used to all camp in a 10p Coleman. Once my eldest turned 11, he wanted his own tent. Now my kids are 11, 15, and 17, and we use a 6p (me and husband), 4p (11 & 15 yr olds), and a 2p (17 yr old). It is definitely much easier to find a flat spot to set up with smaller tents. The kids also set up their own tents. It's easier to keep a smaller tent warm too. For a family of 7, I'd suggest 2x 6p tents. We used our 10p Coleman tent for 11 yrs before we stopped using it. Our smaller Colemans get used at least 7 times per year. They're still going strong.
A few of our scouts use Coleman tents; one has a two-person, and one has a 4-person. They lack a vestibule for storing gear to keep it out of the rain, but they are quick to set up and they aren't horrible quality. Our scouts have been using theirs for a couple years now. You probably already know, but a 2-person tent will only sleep two tiny people, and 4-person MIGHT fit three.
I feel like location may be a big factor. My troop mostly car camp. Very infrequent backpacking. I’m in Missouri and a $40 Coleman 2 or 3 person is a great starting point. If they stick with it upgrade from there.
I have the non lighted version I got on sale from Walmart for $70 four years ago and never had an issue. But I set the tent up under a 10x10 pop up canopy so really the tent has never seen rain.
I'd get a Coleman Skydome for $100. I go camping all the time and that's what I use
All I know is I've had the same Coleman for 4 years and has never leaked nor collapsed. If something happened to it I wouldn't feel bad and get another. If something happened to a $200-$300 tent I would feel bad.

The North Face
Wawona 6
Spacious vestibule, strong in storms, but rainfly tricky solo.

Gazelle Tents
T4 Hub Tent Series
Fastest setup, durable, but bulky and awkward door.

Durston
X-Mid 2
Ultralight, spacious 2P, but not for very strong winds.

Durston
X-Mid 1
Budget ultralight 1P, spacious, but large footprint.

Naturehike
Mongar 2 Backpack Tent (Nylon)
Budget 2P, spacious for price, but not for 4 seasons.

Ranked #1
Durston - X-Mid 2

Ranked #1
Gazelle Tents - T4 Hub Tent Series

Ranked #1
Gazelle Tents - T4 Hub Tent Series

Ranked #1
Durston - X-Mid 2

Ranked #1
The North Face - Wawona 6

Ranked #1
SlingFin - Portal 2