The Who frontman once claimed he had been ‘too critical of our leaders’ to be considered for the honour