I think it is definitely geared towards the younger set- up to 6 or 7.
We did go because we'd never been, waited about 20 minutes, but would not have waited longer. My 13 year old boy, a real pill these days, was chosen by the CM to be a knight. The look on his face was priceless, but he was a trooper and went along with it. Some older moms enjoyed watching him, as I could hear them commenting; I'm sure they remember those teenage years in the trenches.
My girls, 9, did somewhat enjoy it, though only one wanted to have a role (Mrs. Potts), but would not choose to go again if given the chance.
I think it's worth it if the wait isn't long, but I would not use one of my 3 primary FP on it.