Saw this on HBO Family (HA!) on vacation, and what a pleasant surprise! Everyone here is very funny, particularly McBride, and the goofiness of the plot and special effects had me smiling. I particularly love how Grumpy actually has a lot of character in his animation despite looking cheap-but-strangely-beautiful, and the Sleestak suits are a thing of beauty.
And yeah, NOT for children at all. I was gobsmacked by how bloody this movie gets, particularly when the female Allosaurus explodes, as well as the profanity. For some reason "You're a little asshole, Chaka!" has become one of my favorite lines, as well as the "Mexican Vasectomy" thing.