Video game dialogue remains to be seen, but I already find ChatGPT based text adventures super fun! So I suspect there will be demand for both handcrafted static stories and AI dynamically-generated stories (ie they can be different things, one doesn’t have to replace the other, just like email didn’t immediately replace the post service).
I don’t know if you enjoy copilot, but for me it’s definitely supercharges my productivity.