Neural Radiance Fields (NeRF) alone by themselves will alter VFX fundamentally even without all the Stable Diffusion 2.0 (now with Depth!) etc generation.
NeRF lets you pick ANY smooth camera path in a 3D space built up with nothing more than a mobile phone. That's today.
These two phenomena will start to merge and the impact will be as transformative to the software side of media creation as the switch to digital from celluloid was for hardware. There was a time some still remember when not everyone had a camera in their pocket.