“After years of taking heroin, it becomes this black ooze that covers your heart and you can’t feel the music any more”: How Stone Temple Pilots and Scott Weiland gave it one last chance with their self-titled sixth album