Up in the northeast power goes out every winter. It also gets restored a lot faster than the midwest, personal experience, but the reliability of it going out at some point during the winter means that everyone has a wood stove and a backup generator. Portable ones are practical enough and wiring a couple of circuits and a plug for the generator is not cost prohibitive for most.
What I've found in traveling the whole country for a few years is that local power generation or storage always forces you to consider just how little power you actually need. You can pretty much never just power the whole house, or even a whole RV. Even 50amps is ALOT of power and trying to provide that from solar/generator/batteries is incredibly expensive.
So your real question is pretty much never going to be, "how do I power my whole house in an outage?" but rather, "What is absolutely essential to spend up to 3000w on?" and even then knowing that a generator putting out 3000w burns 20lbs of propane in about 4hrs and 3000w for 4hr on batteries would require 10 to 12 100ah lithium batteries at $350+ each.
I still agree with you that super efficient heat pumps are the future without fossil fuels but that probably also has to come with greatly improved insulation values in almost all homes regardless of region. Think double the current DOE recommendations. If you're running on electricity, you will feel the cost of every bit of heat you lose through the walls, roof, and windows. More insulation is a one time cost versus monthly, it always makes sense in the long run.
However, we'll need regulation to force home builders to invest in that instead of just adding unnecessary sqft that people never use but have to heat and cool anyway. For some reason people don't want to pay extra for a house that is well built and well insulated, they'd rather go with bigger is better even when it's already absurd, and builders have noticed this.