Why will programming still be our pivot? There is no perfect software. Every program has resource constraints and unique features. High-level constraints include choosing app submodules to please users. Low-level constraints also exist. Who can decide to cut off garbage collector for performance? Yes, the process in some aspects may become more declarative. But only you know your constraints and trade-offs. And you need to specify these constraints for a hypothetical perfect coding AI. The deeper you start to specify, the more you start programming. Maybe you'll even use "while" constructions in natural language programming.
If we imagine AI knowing all constraints and human needs, we enter sci-fi territory. I think we could collectively write a pretty decent sci-fi novel about this in the comments.
But in the end, the world is very complicated and this is only an opinion.
P.S. Right now I'm going to write code in a completely non-declarative style, and have fun doing it!