They typically generate 10-25% of their maximum output on the cloudiest of days. Most cloudy days are not maximally cloudy.
We don't need solar panels everywhere to get even close to ~100% renewables (with nuclear, wind, new geothermal, and hydro). The areas where you put them are distributed enough that it would be exceptionally rare to ever encounter a meaningful need to ration.
So, storage is an issue, but not as big of an issue as most people think, and we do not generate anywhere near enough solar energy for it to be a reasonable concern yet...
There's also more solutions than just conventional batteries. There's pumped hydro, etc...