Prince William was at "the lowest I've ever seen him" after his wife Kate Middleton was diagnosed with cancer, a former royal aide said. In an interview with 60 Minutes…