Decades ago I wrote a paper, lost to time now, on the effect of his military purges on the fighting effectiveness of the Red Army during the back half of WW2. He purged not just senior commanders but mid ranks and up, think like down as far as their equivalent of majors. A vast amount of battle-relevant experience was swept away, much more damaging in the day-to-day grind than simply disappearing a few field marshals.
My point is, hope is not lost for the US military. Yes lots of irreplaceable senior experience is being tossed aside for unforgivably stupid and pointless reasons, but there's a lot of recent, hard-won, actual shooting war experience in the officer corps which, if they don't all bugger off in disgust, will serve us well in future. Today's captains and majors are well aware of how drones in Ukraine have changed battle[1], to give one example, and the career-minded among them will be in doctrine-influencing and development positions before too long.
I'm aware this is to some degree wishful thinking.
[1]I chose this example because it's going to be one of that drunken fool's more consequential errors: re-tasking the Army unit charged with developing drone capabilities for the US.