Rich natural resources built Aberdeen twice, but today it lies almost abandoned, as our city faces a third major transition — and the renewable energy future threatens same old exploitation, warns LARA FLANNERY