I think that the big dino that jumps at you at the end is actually a Carnotaur, but I could be wrong. DS doesn't like that bit, and he also has trouble understanding that there is no chance of the "big meteor" actually hitting us.
Anyway, just wanted to point out that if you have a kid that like dinos but isn't up for the intensity of this ride, a good alternative is Ellen's Energy Adventure at Epcot. The dinos in that one are the ones from Fantasia, and it is not nearly as intense.