The legendary snooker commentator has overcome personal struggles to become a fan favourite on the BBC