IMHO SD cards fail much more often than the USB-C connector would, what's the worry? If the camera mounts as a mass storage device it's one fewer thing to go wrong.
Secondly, and more importantly, the lifespan of your camera is now the lifespan of the internal storage. That seems very unappealing.