It's possible to build bigger turbines at sea, which are more efficient. The limitation on land is transporting the blades which often requires roads to be modified.
It’s not so much “not in my back yard” as there is no back yard big enough. The article says the new digger bank wind farm will be as big as Yorkshire, which is really very big (in UK terms)