In an abstract sense, yes. Compilers let programmers work at a higher level of abstraction. LLMs bring it to an even higher level, though the abstraction is much leakier.

For the time being, a good understanding of programming and domain knowledge gets you much farther than without it. There might not be room for as many (professional) programmers as before, though.