The West End supremo has spoken candidly about his struggles with alcohol, saying going into recovery is "the best thing" to happen to him