A former aide to Britain's Prince of Wales said he was at his “lowest” after the Princess of Wales was diagnosed with cancer.