The Term "Executive Branch" reflects that although led by the President, it is supposed to be a team...
Most of the day to day decisions and associated work are delegated - that means that even with a President suffering from issues - the ship can still sail (so to speak).
The main problem with Trump, is that he has to personally be involved in everything - and any of his "team" (I use the term extremely loosely in this case) know that if he isn't pleased with what they produce, they are likely to be sacked.
Hence unlike Biden, where there really was a team, with a relatively consistent vision, and therefore people could make decisions and proceed with running things.... with Trump, cognitive decline has an immediate and dramatic influence on actual operation of the Executive Branch.... yeah in the Trump autocracy, if the leader has issues, then the ship is rudderless, drifting, moving in random directions. (something that was not the case for the Biden administration).
Ultimately this is the fundamental weakness of any/all autocratic systems - they are only as good (or bad) as the guy at the helm - and as they maintain their position by squashing any independence below them (for that is the nature of these beasts) - then the whole system grinds to a halt if anything is amiss with "beloved leader".
Good governance is always assured by having competent teams and empowering them - the Trump administration has demonstrably, not got a competent team, and Trump absolutely does not empower his people.