There is essentially infinite demand for software. Every time new technologies have made it cheaper to build software we've ended up with more new software, and more people employed in software development. There's no reason to expect that LLMs will change that historical pattern. We'll just be using higher level tools.

But most of the people creating digital media like animation, graphic art, and special effects are probably screwed. The next few years are going to be tough for them and they have my sympathies, but they're only a tiny fraction of the labor force.