The water system shuts down because the tanks aren't reserve supply they're pressure support.
And solar plus storage will keep you running for maybe a week if you're conservative and mostly don't use anything...which doesn't help you if it's months till replacement.
But yes, unless you spend serious money (own sewer, water from underground etc), it's basically solution for "the power pole is down", not any grid wide problems.
It is often the case (at least where I live) that having a septic system and well is far more economical than obtaining a property with access to city utilities.
They're off grid, and can be swapped out if the PV panels or immersion pumps fail.
Ideally you should be pumping into tanks in any case, for the buffer, and those tanks can be placed on a hill to gravity feed .. or pump with a motor.
Here's a typical setup, sans old windmill: https://youtu.be/iZAMm_S3GNQ?t=383
(same rough area (W.Australian wheatbelt) not our land)
You'd be better off with an air sourced hear pump for hot water anyway - the one in my house uses less power then my dehumidifier.
Which have days worth of backup generator power
> refrigerated food distribution
Do you think refrigerated trucks trail big long extension leads to a socket somewhere?
"Oh but we never get power cuts here!"
Yeah. Try living in a part of the world where 140mph winds for four weeks just just Normal January Weather.
"But if I got power cuts for more than a few hours I'd complain to the provider!"
Yeah. That sure is going to help rebuild 30 miles of blown-over 275kV power line that runs through some of the most inaccessible country even if it's not storm-force winds that prevent access by boat and fallen trees that prevent access by land. Complain all you like, but doing beats talking.
It's expensive these days but it's something I do across a few hundred sites about once or twice a year.