From a Californian perspective, hydro and geothermal are basically tapped as far as I know, in-State anyway. The plants that are operational already is about the extent of what we can probably build.
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.