“I’ve got fame, I’ve got adulation, but I was still in the mental prison.” One of heavy metal’s most iconic stars reflects on the day he knew that he had to choose between sobriety or annihilation