In the literal backyard of my house? No. Of course, I also support windmills, water reservoirs, lithium mining, and electric car factories and don't want any of those in my literal backyard either. The idea that it is hypocritical to advocate anything you wouldn’t want on your own residential property seems like such an obviously ridiculous idea, I'm not sure it makes sense to rebut. There are countless things society wants (factories, mines, landfills, warehouses, etc…) that don’t make sense to do in residential areas.

In my figurative backyard, like the state I live in? Sure, I would definitely support California creating a nuclear waste storage facility.

This isn't really anything groundbreaking. We already have millions of acres of landfills in the US. Like radioactive waste, trash is basically permanent and will be decomposing for at least hundreds of years. And no one wants a landfill "in their backyard," but somehow we still managed to create the thousands of landfills we have today. We can spare a few dozen acres to build a nuclear waste facility.