There's going to be a beautiful synergy here between electric vehicles and solar. Because an EV battery is already easily enough to power most houses through 14-16 hours of darkness, so if it can be a sink for solar during the day it can then be a source during the night. The future will have a combo of residential battery storage and V2H/V2G which has an attractive property that it scales naturally with population (every new person that moves to a location brings their EV battery with them).
It may be true for some who WFH often or in some cases, but not enough EVs will be able to discharge overnight for a v2g battery revolution.
Remember that even my little town car (Renault Zoe) has a 52kWh battery.... which would run my house for five days. So the energy stored in these systems can be considerable.
The people doing these things have thought a lot about it. Take a look at this video - it's a bit 'puff piece' but shows what one way of doing it looks like: