Here's another fairy tale inspired game, albeit loosely, the Sleeping Queens card game. This one uses Sleeping Beauty, of course, without Little Red Riding Hood in sight! And the sleeping women are queens, not princesses, which I find I prefer.
Product Description from Gamewright:
Parents' Choice Recommended. Imagine a place where there's a queen of all pancakes, a king of cookies and a pack of over-protective dragons? If this sounds like something out of a dream, it actually is! Sleeping Queens was invented by 6-year-old Miranda Evarts, who thought up the game one night when she couldn't fall asleep. She awoke the next morning and with help from her older sister, Madeleine and her parents, Denise and Max created this wonderfully whimsical world of napping nobles. As you immerse yourself in the Evarts' fantasyland, you will find a game that helps develop memory, strategy, and elementary arithmetic skills. Just be careful when playing potion cards or you could wind up putting all the players to sleep! Rise and Shine! The Pancake Queen, the Ladybug Queen and ten of their closest friends have fallen under a sleeping spell and it's your job to wake them up. Use strategy, quick thinking and a little luck to rouse these napping nobles from their royal slumbers. Play a knight to steal a queen or take a chance on a juggling jester. But watch out for wicked potions and dastardly dragons! The player who wakes the most queens wins.
Thanks to SkateJ for directing me to this one!