The midfielder revealed he'd been sexually abused as a child, as well as battles with drugs and mental health