The SNP Government's hopes of a green jobs bonanza are fading after an oil giant scrapped plans to develop a pioneering windfarm off Aberdeen.