It's taken me a long time to realise this fact about AI, and although I have come to this conclusion myself, after many months working closely with AI, I hadn't really identified this nuanced limitation of AI as a thing, I just felt that AI was intentionally stupid? Annoyingly lacking in insight?
As the human member of the pair,
I, (you) you have to provide the insight, the leaps for the construction of any new project... It's what you have always done as a programmer, it's what makes you a good programmer, and it's the most rewarding part of programming!
The video indicates that AI is not expected to achieve levels of insight equal to a human for at least four or five years, so there is plenty for any programmer with the gift of insight, plenty of work....
And what is your work? The AI will have a depth of knowledge equal to and often greater than the best programmers... And it will offer you solutions that you have no idea of how they work, but your insight your experience will trigger that instinct, "I don't like that! That feels dangerous" and you steer the AI to another solution.. that's the work, that's the job, and any one on this forum who has developed their own projects will have this in abundance...
So it's not the end of the line for programmers, it's the beginning, and there's no steep learning curve, (that was the scary part), but the AI leverages that aspect...
You will not become an expert Python programmer, ever, but teaming up with an AI, applying your hard won intuition and insight will make you an unbeatable pair!