Maybe the grid needs a multi-source agreement for equipment like the network industry has for optics.
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.
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?