It's kind of darkly funny that NIMBY ever came to refer to housing in the first place. The term was originally meant to apply to stuff exactly like this -- i.e. genuinely noxious uses that most people nevertheless agree are necessary somewhere. Almost everybody is a NIMBY in this sense.
Also, housing itself is often a genuinely noxious use of land for incumbent homeowners. In part because construction creates noise and dust and requires upgrading other local physical infrastructure - but also because more housing implies more new people living in an existing neighborhood, and additional people living somewhere can themselves cause problems for the incumbent residents.
Developers share an enormous role in this problem. They want to enshittify nice places to live with overdevelopment, because people with lower standards want to live there - which is perfectly fine. But they could happily live in residential zones built outward instead - however, that doesn't get the developers as much money, so they don't.