Invitation to the Royal Ballet: the Lowry's Michael Simpson describes his latest exhibition