The man who one said, “I’m a rock star because I couldn’t be a soccer star,” broke through with his solo third album, which included the smash “Maggie May”