“What came out of a tragedy gave birth to something that was hugely positive in my life.” How the legendary Chris Cornell channelled his grief over a dear friend’s death into making one of the 90s’ most underrated classics