It's possible that the people who oppose these projects are not the same people who miss them when they're gone.

Yes, that seems to be a fairly common human behaviour. One of many that may seem illogical. But since they are human behaviour, and we're humans not machines, we should work with it to maximise happiness rather than say "that's illogical we should stop".

Hopefully it will be that way with wind turbines when they are replaced in decades to come with some unheard of power source.

I didn't hear anyone complain when the Tricorn Centre[0] was removed which was called "the 3rd ugliest building in the UK." Several UK prisons are literally more attractive than that place was...

https://en.wikipedia.org/wiki/Tricorn_Centre

Human nature is to reject change, we all trend towards the familiar.

Those out liners that do reject change are usually hailed or hurt.