"But at present it isn't and if something goes wrong it's devastating at least locally."
But it's not devastating, at least not in Japan, and not yet. And Japan had just about everything go wrong that could possibly go wrong, and it's still not devastated anything. And as already said that's with an older design of reactor that doesn't have all the safety features of newer designs.
"why can't we channel that cleverness into making renewable energy more efficient?"
We're trying, renewable energy sources get enormous subsidies and have yet to be cost effective. Renewables are also not yet consistent, when the wind drops the turbines stop, when it's cold the turbines need more power than they can produce to stop them freezing and so on.
We're also trying with the ITER project which while "nuclear" is different from current reactors and if it works will be much safer.
So while we continue to look for long term solutions we need an answer now.
And that certain anti-nuclear parties are having to use the politics of fear to get what they want does make you question how good other arguments are.
Japan should serve as an example of the punishment that you can deal out to even old nuclear reactors with, as yet, little serious repercussions. It's not over yet, but those that have been saying "the procedures are working" have so far been proved right.