Actually something of a dream of mine is to see nuclear reactors eventually replace some of our dams, maybe restore some of the lakes and tributaries that have been lost, but presently new reactor construction is prohibited here per a ballot initiative from before I was born.
My larger point is that society is going to continue to demand increased electricity generation, which means new plants and installations. It’s one thing to want to replace existing installations but if you’re going to service future demand, then new sources of multiple types have to remain on the table. I would take nuclear over gas-fired plants, but I would take gas-fired plants over coal-fired plants.
For what I understand, the California State Water Project as visioned in the 1960s, had Stage I and Stage II. Only Stage I was built. Then from the 1980s onward, there was political opposition and Phase II was never started.
https://en.wikipedia.org/wiki/California_State_Water_Project...
Geothermal I think only works in some places without causing earthquakes. [3]
Wind and solar are good, though.
[1] https://www.science.org/content/article/hundreds-new-dams-co...
[2] https://www.utilitydive.com/news/hydropower-emissions-fossil...
[3] https://news.stanford.edu/2019/05/23/lessons-south-korea-sol...