There could still be a great future in that from stored thermal energy from renewables. I harp on this a lot here; the estimated cost for 600 C heat available with 100% capacity factor is $3-5/GJ, just from resistive PV heat.

Not going to happen.

Well, if we want more drinking water we might start boiling salt water with electricity.

99+ missed calls from millimeter wave bored geothermal

Or as Bill Mckibben observed "for 10's of thousands of years, humanity has burned things to produce energy. The period of fire is coming to an end".

That's why I hope Helion Fusion does well. The system they are developing sends power to a device that captures power directly no boiling water.

“How did humanity solve climate change? We taught sand to move electrons with photons.”

Except for solar collection that boils water to generate power.