Aberdeen has always been synonymous with opportunity. But that has begun to change: the eclipse of fossil fuels and the Net Zero agenda have played their part.