My kids loved this ride also...I however, got a little sick. I am prone to sickness, but read every post here about this ride beforehand. It just goes to show you that everyone's experience is unique and you'll never know unless you try it!
That being said, my dd 4 adored this ride, but she never gets scared. My ds 6 who gets scared on everything even loved Soarin. For the poster who didn't know what kind of ride this is, it's a simulated flying ride where you sit in front of a screen that has various settings like the desert or over water, or my favorite, the fireworks at the MK.
I do recommend that you sit in the second or third row if you are a little apprehensive, like me. I think I would have been even sicker if I had been up any higher!