All the things mentioned in the article really are prime candidates for automation. But that's management, not leadership.
Management is primed to be automated. See Marshall Brain's book "Manna" for a great take on what's possible here.
Leadership is not. LLMs are great at doing the right things when there's a general consensus on what the right things are. Best practices, etc.
But what the current technology cannot do, and what I think LLMs specifically could never do, is know when to break the rules.
As Phil Knight may or may not have said (he was quoted in the new Air movie): You're remembered for the rules you break. That's leadership.
A great CEO needs to be a leader first and foremost, and a manager second.