Not everyone. People were picketing the state capitol in New York for like 3 years during the fracking boom and were successful in stopping it.
The folks without mineral rights and with worthless homes with no clean water aren’t so happy either. The company is usually bankrupt so there’s nobody to sue either.
Why do you think that is?
(The answer, of course, is money. Nobody gets rich storing nuclear waste, but extracting mineral resources is a money printer - especially when you aren't saddled with the long-term consequences.)