Solar, wind, or geothermal power won't be enough to overcome the problems mankind is facing. They are simply no where near good enough!
That is not quite right. It would be difficult to produce all of the energy we need from these sources with today's technology, but with some improvements we could do this, and it would be at a lower cost than fossil fuel. For example, suppose you convert wind turbine output into hydrogen fuel (gas or liquid hydrocarbons). This can be done today, but it is not cost effective. Suppose the technology is improved and we install wind turbines in North and South Dakota to do this. They would produce more fuel than all of the oil wells in the Middle East. It would bankrupt OPEC. For most applications we could use hydrogen directly. For hydrocarbon fuel, we might use carbon from garbage or extracted from air, making it zero-carbon. This would be expensive but do-able. Either solar or wind could be used to make synthetic fuel for transportation, not just electricity. Generating electricity from hydrogen gas would solve the problem of distributing the power. Hydrogen gas pipelines have been used for over 70 years in Europe. Gas could be sent to distant cities for power generation on demand.
The amount of potential energy from easily accessed wind and solar far exceeds total human consumption. In the U.S., one large solar installation in a place like Death Valley could produce all of the energy consumed in North America. In the Middle East they are now constructing solar farms ranging from 1 to 4 GW, the equivalent to 4 nuclear reactors during peak hours. Which is when they need the electricity, because air conditioning is a major demand.
One of those 4 GW sites now under construction has a concentrated solar portion which will run well into the night. In that desert area, solar is far cheaper than nuclear or fossil fuel. In Saudi Arabia they plan to build a 200 GW solar farm in stages by 2030. Their total electric power production at present is 77 GW.
https://singularityhub.com/201…er-than-any-in-the-world/
Wind in the North Sea could provide about 4 times more electricity than Northern Europe consumes.
Needless to say, cold fusion would be far cheaper than these methods. It would be roughly 200 times cheaper than today fossil fuel systems. See:
https://www.lenr-canr.org/acrobat/RothwellJcoldfusionb.pdf
It would have many other advantages:
https://lenr-canr.org/acrobat/RothwellJcoldfusiona.pdf
However, wind and solar could be far better than what we have now, despite being spread out at low power density.