The motivation for green energy sources will always be there, because as you also mentioned, nuclear energy is not ideal. I am still a strong supporter of actual green energy sources and changes in habits to reduce energy demand. But if I had to choose between replacing fossil fuels with green energy over time, or changing nuclear energy with green energy over time, that's what I'll choose.

It feels indeed like choosing between pest and cholera. I think it all boils down to the question: Do we want a lot of slightly bad carbon waste that we cannot contain, or do we want a fraction of that waste (less then one millionth to be precise) but which is highly dangerous and lasts 100 times longer. And perhaps this will always be a personal choice.