The former Manchester United boss's brother is living with dementia and the star opened up about it on BBC Breakfast