The whole point of AI is that you don't need to be the best at anything... You outsource knowledge to AI. AI is an automation tool for knowledge work, you can't secure your career by moving into another form of knowledge work – especially not one with an even lower barrier to entry.
If AI is going to replace a programmers role, it will 100% replace any LLM expert / LLM prompter role.
If today:
Come up with some requirements -> programmer -> app
Why would the future be:
Come up with some requirements -> LLM expert -> app
Instead of:
Come up with some requirements -> app