The Prince and Princess of Wales and their children had a candid conversation about sport and being "embarrassing" parents at the Commonwealth Games.