No, definitely not scary -- wimp here.
BUT, the beginning of the ride is indoor, lots of abrupt stopping and starting. I do suffer from car sickness unless I'm driving, so this part actually got me a little queazy. The end of the ride, you're outside and it's a straight shot, so that part actually helped me feel better.
But not scary at all. If anything, pretty informative.