“She was very, very honest, almost to a fault. Most singers are actors. Sinéad was not an actor.” Smashing Pumpkins’ Billy Corgan recalls Sunday dinners with Sinéad O’Connor while she was holed up in a friend’s attic