The legendary Manchester United manager has spoken about his dementia fears in a rare interview