You say that you liked learning how things worked inside out, whether it was Postgres or whatever. You can still do that. You can learn it at a high level, and then it becomes like a magic word in your arsenal. You don't have to know or remember the details of implementation, but only the nature of its costs, benefits, and synergies with other systems. You just have to remember that high-level abstraction, maybe just a single vocabulary word, of a low-level reality - the exact syntax is really no longer a concern.
The better the agents get, the less there is playing manager. Really your job now is to have and execute vision. Execution is largely a function of having a map of the high level vision and low-level realities in your head, or just having in-the-moment intuition about these things... then just speaking it.
Also, there is developing personal libraries. You may find that in your business you repeatedly tackle similar problems. You develop and refine a library that your future agents can utilize. You develop prompts that make your work more automatic and more robust. And when I say you, I mean, you direct your agents to do it.
It's not so different from what it always was, except that years get compressed into months. What was slow and tedious is now... less so.
I don't know how much advantage I have in this new world, having programmed (sometimes more, sometimes less) for 30 years. My brother has never written a line of code in his life. He's been heavy into AI for a while, and he has developed some really incredible stuff. I think he may have already outpaced me. His $1500/mo+ in subscriptions definitely help.
They can build things, but it's all terrible really. Their "ideas" are terrible.