Thank you for not taking your little on on this! Every single time I ride there's some parent bringing a small kid saying 'hey, it's a ride with dinosaurs, you'll like that!' and obviously not realizing that these are NOT the nice, vegetarian types. It's like Snow White's Scary Adventure in a larger, darker building with Tough To Be A Bug level noise and jumping out combined with the Alien scene in The Great Movie Ride level scares. Doubled. At least. No, parent in line ahead of me, this is not a tame little dino ride that your child will smile their way through.
Fortunately, as you've found, it's hardly the only dino experience to be had in Disney. Besides Chester and Hester's little roadside dino place and the boneyard (I so wish I was small enough to run all over that!) the gift shop is a treasure trove of dino stuff and over in Epcot the Universe of Energy has a dino section (and these are the far tamer type - still carnivorous but they don't see the guests as prepackaged chicken nuggets) that I think is good - I've never actually stayed awake for the whole thing.
And please bring some earplugs for at least your younger kid - I don't have any sensitivity issues, I don't get overwhelmed easily, and I've been going to Disney parks for almost three decades and I STILL find the whole experience overwhelmingly loud and chaotic. Fantastic, fun, amazing, but loud and chaotic!