Lead guitarist of Queen, Brain May, penned an emotional note in memory of the football legend, calling him half-angel, half-devil and all genius