sure its not magic, but there are ways to store it, and at least with solar the peak production also tends to line up with the window of heavy demand, especially in hot summer months with AC load. The other nice thing is that solar can be put on a roof, so it doesn't require extra land, or it can be placed on land thats otherwise fairly useless. Locally there is a solar farm being put in on top of the old landfill. Fill in the rest with nuclear for base load and we have a solid grid without having to deal with shipping goo around.The fatal flaw with renewable energy is its inconsistency as a reliable source.
Fossil fuels may be the most cost-effective but it brings with it leverage. Places that have it know other places need it, and controlling the resource gives them power over others. Its no different with any resource honestly.