If you ask 100 people, 99 will tell you that they rather live next to a solar panel or a silicon extraction mine than next to a nuclear power plant or a uranium mine.
If you ask 100 people, 99 will tell you they would rather buy new electronics every year and throw away the old, and they would rider drive a huge SUV than walk or bike.
That doesn't mean it's a good thing.
I don't think that's true.
Anyways. We are comparing nuclear, radioactive waste that has the potential to make whole areas of land unlivable for decades if it touches them and stays radioactive for a million years to cadmium, which is much less toxic than nuclear waste, has a shorter half life and in doesn't require us to find a solution to an unsovled problem to deal with it.
How can you seriously compare the two on the same level?
I'd guess that most people would rather live near a solar panel or a nuclear plant than a mine. One is potentially dirty and disruptive, the other IS dirty and disruptive.