Dessert Nomad
Adventurer
In the purple worm scenario, I'd assume any container of that size would be on a pack animal leaving perhaps only a few smaller water skins for filling.
Better hope you have a clean barrel in which to store those 10 gallons. The spell doesn't create a container. And it's ONE container - unlike the 3rd level spell.
I would not assume that every tarp and tent was on the deceased pack animals and is now consumed, that every barrel, cart, or large pot was completely obliterated, and that they players can never find a cactus or tree to hollow out. The spell only requires a single container, it doesn't require something like 'a single container suitable for long-term storage and transport', so a mostly waterproof tarp or tent made into a bag works fine as the place to summon the water. You then fill the smaller portable containers that you have from the single large vessel and drink as much of the leftover water as you can before it leaks out of imperfections in the vessel. "Clean" can be dealt with either by prestidigitation or spending 10 minutes to ritual cast purify food and water (which the classes that create water also have).
Things like 'there are absolutely no items you can use to improvise a short-term container to summon water in' or 'your party doesn't have a drop of water in any of their waterskins and can't manage to cry about their situation and someone stole all of your holy symbols and druidic focuses' don't feel like actual world obstacles to me, they feel completely arbitrary and non-immersive. That kind of thing reminds me of the bits in the Fallout games where you'll have a locked door with a large broken window in it but can only get through the door by picking the lock, you can't possibly knock out the rest of the glass and climb in or use your power armor to punch through 200 year old drywall; it's the kind of thing that can take you right out of the game world.

Either way, any time the party needs to expend slots to deal with this stuff, it's less slots for bless, healing and the like. The DM is placing strain on the party. It doesn't always have to be killing PCs or reducing them to single digit hit points.
Again, spending a first level spell slot is a mild annoyance, it's just not a huge deal unless you have some other, much more extreme stress on the party - and if you do that, the more extreme stress is going to end up with the focus, not mild inconvenience of the lack of water. A mild annoyance is just not in any way commensurate with the 'stranded in a real-world desert with no water supply' scenario that people try to relate the situation to. Or worth a significant amount of 'justify to me how a character could possibly make a container that can temporarily hold water long enough to fill waterskins from it' discussion (especially if the party has someone with proficiency in survival).