My son loved it. He has older and younger sisters, and I can honestly say he liked the experience every bit as much as they did. They gave him a sword, which he adored, and he almost swooned when Sleeping Beauty kissed his cheek. We went when he was a toddler and when he was 6, and both times it was a hit.
Now, in the interest of full disclosure, DS LOVES the ladies. We're talking about a kid who was "engaged" at the age of three, and then stepped up to being "in love" with his friend's MOTHER at the age of five!