The Duke of Sussex made a surprise appearance at the Super Bowl alongside his cousin, Princess Eugenie