The compute module has 4 holes for bolts at its corners. If it's securely bolted to its board, with the correct spacers, I expect the contacts would experience no relative movement and be pretty good, at least until the vibrations are so severe that the bolts start to come off - but there are thread locker adhesives for those use cases.
--Edit: This is of course for the Compute Module only. The board it's bolted onto should of course be designed according to the use case - I doubt the Curtiss-Wright milspec thing shown in the article uses anything like the official Raspberry Pi IO Board, or the many semi-nameless ones you find on Amazon. I also doubt MicroSD is an option, given that I've had a card fly out of its socket in one extreme case.