i haven`t seen that program...
But the fossils that we find are mostly those that have been preserved by flowing water...there are a few that have been associated with `tar pits` or catastrophic sand storms, but most of the dead bodies would have been scavenged and not preserved had they not been covered quickly...
I wouldn`t go as far as saying a global flood as this stinks of some Babylonian myth, but i would agree that migrating dinosaurs would certainly drown as they crossed flooded rivers etc... :-)