The Sleeping Beauty was always Joan Denise Moriarty’s favourite show. As Cork City Ballet prepare to produce it in November, Jo Kerrigan talks to Alan Foley about its particular magic