Wayne Rooney has said he feared his mental health and drinking problems could have killed him during his playing career.