Royal historian Robert Hardman tells PEOPLE that Queen Elizabeth sincerely hoped the rift between Prince Harry and the royal family could be mended