The former Sunderland player has bravely opened up about his mental health struggles after retiring