I personally don't find the ride scary at all..I find it fun. But there have been a few times where I've seen children scared and it makes me chuckle lol.
It can scare some kids, but then other kids are perfectly fine. It's dark, bumpy, there's dinosaurs (One of which looks like it's chasing you but some people don't see it), and sometimes loud. If you're kid would be into that, then definitely do it.