The rocker watched in horror as the underdog pulled off one of the biggest FA Cup final upsets in recent memory