Yes. this was the showrunner explanation, and it was dumb as hell. There's an easy way to see this. Basically, imagine the absolute best and brightest in leadership in the present day, who have a combination of command training and technological knowhow. Now put him or her on the NX-01 after a training regimen which brings them up to skiff on the technology. Are you honestly going to try and tell me they won't be better than Archer? Of course not. The issue isn't that Archer wasn't Picard. It's that (in the first two seasons) he's portrayed as an incompetent even by modern day standards.
I think the problem wasn't him being a flawed or incompeten in some regards. It was that the writers didn't even seem to notice his behaviour was unacceptable!
As a good counter-point, look at "First Flight": In this, Archer is brash, brazen, over-confident, and lacking fine-tuned social skills. But at the same time, he was also an amazing pilot, and an
expert in knowing both his ship and the complex warp technology! That was a well-rounded
character - I could believe this guy sitting in the cockpit of an experimental starship.
In the same way, had "main"-Archer have the same character flaws (lack of fine-tuned leadership skills, comparatively little basic nowledge of the universe based on human's little experience, a little predjudice - all that would have been fine, if it was also made clear that
was the best and ONLY one to command this experimental vessel - that only HE wa well versed enough in ALL the technologies on the ship
and the theoretical backgrounds of the warp drive, that Starfleet considered him the best choice to basically not blow up this ship accidentally. But that all his other flaws were serious deficiencies that he would have had to work on. Hell, that would have been a great
character arc.
Instead, he portrayed all these flaws, but the writing made it appear
as if he was in the right all along. That he was a dick to Vulcans, but hey, they kinda' deserved it anyway, and Archer turned out to be right about it! That was simply bad writing.