“I’d been living in a dark room, drinking and taking drugs, and I was done with music. My heart was too broken to think about it”: This frontman overcame death and the loss of his band to make one of the 90s’ essential metal songs