The ex-Aberdeen and Hull City attacker opened up for the first time on his illness during a candid interview with BBC Newsnight