In scenarios where you're out of municipal water a few days like is happening right now in Houston (Myself and my family have been through Allison, Rita, Ike and now Harvey) then having a water cache for a week is reasonable, though really hard to do, but that's really not what we're talking about.
It really isn't a prepper mentality. It's just how I prefer to live. Quite a bit could happen and my life would remain fairly unchanged.
I don't have these things so much for what people picture as emergencies. I have them because they are pretty necessary to live here. We have fairly high winds and blizzards that mean mains power is not very reliable. We have ice storms that shut things down for a while.
It's a bit of work, but it is enjoyable labor.
I wonder if there are more in garages or more in basements. Hmm.
Definitely an outlier but I would suggest purifying all water you consumer if possible.
But I feel bad for people in places like Las Vegas and much of Nevada, New Mexico, Arizona, etc. where foraging for water means death.