That video was a great simulation of a lawn sprinkler. Any seam-sealed tent on the planet would pass that test. If you plan to camp in the back yard with the sprinklers on, you'll be fine, except for the condensation Steve mentioned. Forget the goofy video, let's talk logic about the range of shelters and conditions on a 7-day trip camping at 10,000 ft.
Start with no tent. You'll be just fine for maybe 80%-100% of the nights on an average week in late July. Do you feel lucky?
How about that 5x7 tarp you inquired about in another thread. Great for the backyard sprinkler rain test seen in that video. Not so good for winds above say, 20 mph. If the direction is consistent, you might be able to pitch it well with some skill. Most likely the wind with shift and you'll get soaked from side spray, even in a light rain with high winds. You'll survive, but miserably. A couple days of that and you'll be looking for an exit trail.
The Walmart special might give you more coverage than a small tarp, but the 2-poles system is probably heavy small-diameter fiberglass, prone to bending and buckling in high winds. Extra guy lines can get you through a moderate storm, but there are limited tie-off points and weak stitching for serious wind gusts. The rain fly is partial coverage and doesn't seem to allow much air flow between the fly and tent. That design is a perfect recipe for condensation. Does it matter which way your sleeping bag gets soaked, from dripping condensation or wind-blown rain or leaky seams? You're screwed either way. With all that said, the odds of this happening is still only 5-10% on a 1-week trip in late July, in my estimation. If you get hit with a lot of snow, all bets are off. But at least you'll have some protection from the bugs. If you're on a tight budget, and you can use this for car camping, and you feel lucky, what the heck. Be sure to seam seal it, set up extra guy lines before you go, and try to keep the windows cracked for extra ventilation. You'll live. Don't worry about a footprint under the tent, it's disposable, and something else will fail before the floor does.
Think about renting a high quality tent, but most of those are heavy so they can hold up to the abuse of rental equipment.
Consider a larger tarp that will handle side winds. Practice practice practice pitching it in various configurations.
Lastly, and perhaps the best advice, use your google skills to hunt down a used tarptent or lightweight backpacking tent that will last you for years and get you through the tough times. If you hike enough, the storms will find you and you'll be glad for your investment.
