Mike Tindall was once left in a "bit of trouble" after making a brutal joke about his cousin-in-law Prince Harry following his decision to step down as a senior royal.