It's all context. Nuclear waste (as in from commercial plants) has yet to kill anyone in the U.S. and it decays to lead eventually. However, mercury, which never decays, is a byproduct of many processes (not to mention coal burning) and kills/maims many.
A few hundred years is a helluvalot. It may all in all be better than fossil, but definitively not too good to be true.