These two aspects:
Many types of software simply doesn't need to be created any more.
Writing software is now (mostly) about managing LLMs.
...is not a pipe dream. It's here now.
There's definitely hype and pipe dreams on top of whatever the baseline reality is. We can always expect that. And there are non-technical reasons why some people/firms can't or won't use the leading products from OpenAI and the ilk.
You may be right about the "robot value chain." It certainly looks like the age of AI has widened the divide between software developers building AI and everyone else.