Mike Tindall, who is married to Zara Tindall, the daughter of Princess Anne, has opened up about his relationship with her grandmother, the Queen, and how it almost took a painful turn