I'm a big chicken that doesn't like the big coasters. I have ridden, but probably won't ride again: ToT, Space Mt., California Screamin' (at DL). I have ridden and probably will ride again if I get up the nerve: RnR, Splash Mt., Soarin'. Rides that don't bother me: Kali, Big Thunder Mt., teacups (as long as I'm with my preschooler, not my teenager).
Dinosaur doesn't even come close to a ride that upsets your stomach. It's jerky, but not so bad like a coaster. The story line is so good, you'll be glad you rode it. Just make sure you sit on the far right, front row (hee-hee).
Mary