“Between girls, drugs and an entourage he’d bring everywhere, Pete was out of his mind more than at any other point.” How I Don’t Wanna Be Me gave gothic metal icons Type O Negative their last big anthem, but spelled the start of the end