In his book, 'Rod: The Autobiography', the Hot Legs singer explained that he thought he was as "fit as a butcher's dog", but a health diagnosis left him feeling "fearful"