“Shannon’s sister and Axl Rose were in school together. Labels jumped all over us cos of his connection with Guns N’ Roses”: Blind Melon were more than just a grunge-era one-hit wonder – but tragedy cut their career short