Well the Militia outnumbered the invading Brits but they were lolworthy. Based Federalism failed to keep up the bare minimum of standards.
Not so much an issue now I feel with a proper National Guard and Army Reserve system. I've kinda wondered how things would look if the Active Duty Army was largely downsized and then we pass on some of the savings to things like Special Forces, the National Guard and an expanded Army Reserve maybe and so you'd have semi-ready National Guard units and then the Army Reserve could have cadres around which formations are built around them if we need to do some sort of serious military deployment.
And we'd still have a thick, if not thicker Navy and Marine Corps and Space Force, Air Force blah blah blah and so forth. Your MOS of military intelligence or whatever it is you do would probably be okay along with other myriad support roles I imagine.
It'd never happen but it does seem like it could be practically done and maybe there'd be some sort of fiscal (and other) benefits to it.
I personally see the Corp of Engineers as the best justification for our current standing army, with anti-ballistic missile/air defense duties being a close second.
Drones, planes, and ships are going to matter more than numbers of infantry going forward in most conflicts, and the US Army really doesn't like taking backseat to the Navy, Air Force, or Coasties, despite the other services needing far more maintenance and logistical support to remain effective compared to maintaining some infantry and armor divisions.
But the Army forgets the lead times for the other services are not as short as their's, and thus keep shortchanging the long term needs of the Navy, Air Force, and Coasties any time an Army officer gets to be in the SecDef or similar spots.
The focus on COIN has gutted our maritime logistics capacity, which was already getting worse because the US stopped building many ships, due to the unintended effects of both the Jones Act and that the US gov would not subsidize civie shipbuilding like many other nations do to keep their yards running.
When our Navy and Air Force is getting gutted to satisfy the desires of the Army, our nation ends up so much weaker. No amount of infantry or armor can make up for a lack of ships or aircraft, and the Army just doesn't want to deal with how it's obsession over infantry and COIN work has left the US vastly under-prepared not just for foreign conflicts, but some types of domestic emergencies as well.