Should a permanent economic subsistute for oil ever materialise then Aberdeen will be dead
Along with every other equivalent city servicing the same industry. I don't think wind farms come into it TBH. Fine for the next 25 years as a stop-gap 'til something better comes along. Hopefully 25 years hence tidal will be up and running. At least the tide is guaranteed, with only slack water being an issue. Wind however, don't blow all the time, or there can be too much of it sometimes, with interesting consequences...
Issues of no wind and/or slack water could of course be solved through energy storage - an interesting concept being developed for such
here.
Scotland should be well placed for renewables. With the political will and suitable economic framework the eventual downturn in oil production/revenues can be (partly) mitigated.
It'd be nice to think that in 25 years the numbers of these could be reduced through increased generation from tidal energy...
Bit of an eyesore IMHO.