In a recent study, researchers from the European Environmental Bureau (EEB), the Stockholm School of Economics (SSE), and the Potsdam Institute for Climate Impact Research (PIK) questioned the planned development of new nuclear capacities in the energy strategies of the United States and certain European countries.
Those potentially have the same issue. The solution to filling the gaps in production from renewable sources is not necessarily more panels or more windmills, it’s having energy storage somewhere to keep surplus energy when it’s being produced (e.g. during the day, or when the wind is blowing) available to be used when it’s not.
So in your example, each home could also have its own battery bank. Or, a larger battery bank could be placed somewhere on the electricity grid.
It could be a wall of small wind wheels for the home and yes a stored battery location on-site. A friend of mine took us to see their friend who had their own small(ish) wind turbine and it only had to have 10 large batteries. That was years ago.