The rock icon made his drug confession on the 'Real Time' host's podcast.