Matthew Bourne’s Sleeping Beauty, his third and final reimagining of Tchaikovsky’s ballets, is entertaining but not quite enchanting audiences at The Lowry