I think the key is figuring out what will work best for a given locale. Tidal is useless in the Sahara, and solar isn’t much good in absurdly rainy places like Prince Rupert. But reversed there is huge potential.
What won’t work is massive megaprojects like dams and nuclear reactors. The future lies in basically combining everything that works into an effective grid, and backing some of it up with traditional generation (as little as possible and only for peaks etc).
Solar is somewhat predictable, wind can be useful, and the tides can be predicted years (decades?) in advance, to the minute. And there are hundreds of technologies in development that will help all of them deal with their issues. None of them leave highly toxic waste that takes millenia to degrade.
