Seems like those systems should have a battery backup? Pretty easy fix.
A car on summer tires doesn't drive very well in the snow either. That doesn't mean cars don't work in snow.
I have never made that argument nor do I remember anyone in the thread stating that. Our power grid will always be a mixture of sources.
And it was ultimately built:
https://www.nytimes.com/2024/01/04/climate/vineyard-wind-massachusetts.html
As far as not wanting to look at them... too bad. There are lot of things I don't like looking at but unless I own the land I don't get much of a say in it. That's life.