"She might be the Princess of Wales, but she is still a mother and wife," Queen Elizabeth's former press secretary tells PEOPLE exclusively