To be very honest, I feel like the car culture in the US gives every household a potential large battery to sustain their house with. In a future where every car is an EV, every American house has two giant batteries, if not more, hooked up to it all night.
Modern Teslas can store double the daily usage of a US average household. And that's assuming you have literally zero generation at night (hydro / nuclear / geothermal / pumped storage ).
A) How much electricity do you think is consumed at night? ( US average daily consumption is 30 KWh)
B) How much electricity do you think can be stored in a car battery? (Tesla batteries are >= 50 KWh )
C) What happens to existing sources of renewable power that will continue to operate at night? ( They can still provide a baseload that accounts for any shortfalls )