A former palace aide of the Prince and Princess of Wales has shared an insight into the private lives of the royal couple in rare interview.