While I don't love the article, its wording and the rather pompous "/notes$ cat working-with-ai.md" gimmick ... oh you know what cat does?
I agree with part of the thesis, a lot of the skill set (not the people management bit) of being a team lead is like working with LLM agents. Purely in a technical sense. Having a plan of overall direction, guiding agents that go off track, overseeing progress and maintaining the high level direction of whos doing what and whats upcoming. Also sometimes learning from a agent/team member and sometimes correcting really dumb ideas.
No, you don't need to rewrite the app in newest JS framework, just use postgres and be happy.