As Melissa Auf der Maur opens an exhibition of photographs from her years inside Hole and the Smashing Pumpkins, she reflects on life behind the scenes, the trust that made the images possible and what her generation lost along the way