A Caribbean castaway on the brink of death after 26 days adrift has been rescued by a Royal Navy warship after a sharp-eyed sailor spotted his boat dead in the water.