You can stream it. Here’s an example using Unity: https://appmana.com/watch/virtualtestdrive
For runtime loading in such an architecture, you can using an asset like TriLib.
There are many streaming ideas. Most were poorly executed. I wouldn’t generalize based on those. It is definitely the future of delivery for many reasons besides technology.