There are whole ecosystems we've basically never sampled.

This drives me crazy. Along with the fact that we'll probably never know about the various colors and fleshy structures that these animals had.

Yeah I was gonna say, one of the defining features of the large sauropods was a low body density due to the air sacks in their huge necks and hollow bones. Those adaptations were likely required to achieve their size. So you have a really big animal with relatively low density and high surface area, that thing is going right up into the sky and getting smashed to bits when it lands.

Oh I never really thought about the fossil record being sedimentary, this largely aquatic and adjacent environments.

clearly this means there were sauropods with wings, who evolved to use tornadoes for transportation

You just do a quick laydown and tuck your head under your arms, and find a bit of dirt to hide behind.