I believe the transfer will simply be bottlenecked, like running a raspberry pi from an sd card.

To fully utilize the connection you can use storage backed by memory. For example ESXi allows you to back a vm by a "virtual pmem" disk that uses a chunk of your host system dram