Prince William was at his 'lowest' point in the wake of Kate Middleton's cancer diagnosis, according to former aide Jason Knauf.