The star opened up about his near-fatal overdose on Revival, his ninth studio album that was released in December 2017