Meeting Queen Elizabeth II was often as complicated as it was exciting, as one iconic British sporting hero found out the hard way in his meeting with the late monarch