Solar now being the cheapest energy source made its rounds on Lemmy some weeks ago, if I remember correctly. I just found this graphic and felt it was worth sharing independently.
Yeah, that doesn't scale well at all. Batteries are expensive, dangerous (so lots of safety measures at scale), and consumable, which is why very few places actually try to store energy at any kind of scale.
Until we have a good, cheap way to store energy, solar will be a supplemental power source to help with peak demand in the daytime. So we'll need something that's reliable and inexpensive to provide power the rest of the time. For many areas, that's coal or gas, but it could be nuclear. If people just accepted that nuclear is safe and effective, costs would come down.