As with every complex problem, nuclear is a flawed option, but one that offers small advantages for a limited timeframe. Gas and nuclear will not be discarded for years. Real world applications are rarely “either/or”, but more of a market with many goods served.
But, some facts for the pro nuke crowd here:
Soon, rivers will be to warm to cool down nuclear reactors. Unless you want to kill many things living in the water, but no one proposed this, yet.
And the rivers carry less and less water during summer.
The storage was never done for the full time scale necessary, so we might overlook problems. Scientific knowledge progresses, but also earths bodily nature has some surprises in stock. Like in Fukushima, where expectations/specification and real natural phenomena collided catastrophically.
Fusion and fission generate heat. While about 1 % as bad (source: minkorrekt podcast, german language only) as CO2 emissions, we still would need to compensate (even for having ideally cheap infinite fusion energy that would cause rebound effects of increased consumption) by for example using only short term tested carbon capture and storage on a global and permanent scale.
Another way to cool down earth is painting the ground brightly. Or having plants that are brighter to heat radiation than concrete and tar in urban settings. Gras required water but does an ok job. Solar power panels have the same albedo as gras, generate electricity and require water only once during construction. So at least this kind of renewable energy source, but also others, tend to have lower hidden costs and/or effects of placement in a global heating scenario.
Nowadays, wind power is so much cheaper than nuclear that that Germany imports power from denmark (with a high wind percentage) and exports it to France (where a high percentage is nuclear power).
BTW, I really like the investigation of how to harness fusion energy: the project to do this creates scientific progress and productional-and-measurement capabilities which are going hand in hand in increasing our knowledge and capabilities of gaining more knowledge with all of these tools. The Stellerator project (Wendelstein) has a great return in investment. But using this energy source could be counterproductive for a long time on this planet.