Prince William was at his “lowest” after Princess Kate’s diagnosis, according to former aide