Trade unions accused the UK and Scottish governments of “a decade of failure” in securing offshore wind