My first thought was "can you boot from a PCIe SSD?" (looks like the answer is "no" from what I see). I wish there was a RPi with 16GB or 32GB of storage soldered to the board. Where I work we're using Raspberry Pi devices for industrial use and corruption of/wearing out the microSD card has been something we've wondered about. We could just buy premium microSD cards but having a "proper" SSD soldered to the board wo…
It depends on what you are needing to optimize for, industrial use is a very broad category. If you’re caring about the SD card’s endurance for reads/writes, I recommend trying the “high endurance SD” cards. I’ve had good luck with them having continual read/write activity over long periods. If however your concern is mechanical failure due to vibration, stay away from the SD card entirely. Pretty much guaranteed it’ll fail if it’s a high mechanical stress scenario. You’ve got two good options there I can vouch for, use a Compute Module w/ hard soldered eMMC or boot from USB instead. The compute module route is the best in my opinion, but doesn’t always fit the needs, and for those that don’t I recommend USB booting.