When Andrew's naval career wound to an end, he became a man with limited horizons whose interests rarely strayed beyond golf, videos and women, a new book reveals.