So every Starfleet Officer better be a God among men who can do anything and everything, to the point where Geordi/Scotty level engineering miracles are things that our initiates do in their sleep? We're all Sapient here, we falter and fall short, we have our foibles. Sometimes, it seems like the Federation Council doesn't understand that. We got reamed over shit the damned Cat people fucked up, and we lost men because of those idiots.
Frankly? Yes, that is the expectation.
I'm not even being entirely facetious here; "But we've tried!" is literally not an excuse. I would know because I have a degree in (inter)national security and law, and one of the literally first things you're taught is that this is not an excuse unless you really, really want that early retirement.
People in position of high-level military and government authority are frankly expected to keep everything running at 100% regardless of circumstances, and in most cases they aren't even offered thanks for it. Realistically yes, it is impossible to keep things that way, just as it is realistically impossible for the person in charge to be aware of, and guide every single of their staff. But the expectations and responsibility are there, and in a democratic system these people will usually answer to people who frankly tend to have no notion of the picture behind the scenes. Most of the time, all they know is that we had a job, we had the resources, and we fucked up. What gives?
You can naturally push back, and I'm a bit surprised that we don't see Starfleet Command regularly making the argument "if we had the resources on hand/well, you did XY in spite of our advice...", but that's not actually going to remove the fact that we're
answering to someone. Federation Council had given us a job; whenever something goes wrong, it's basic operating procedure to grill the Commander, Starfleet over it. This is even more true when in a society like Federation, where everyone and their cat can (and probably does) send tons of spam email to their councilors over how
they could run Starfleet better, or more efficiently.
And frankly, the Council is generally pretty lenient with us. In an actual real world we'd not only be raked over the coals, but we'd not even be thanked for a job done right except when it's the election season. Meanwhile, the Council, does pretty regularly reward us for doing good work, and for going above and beyond our duty.
It's, you know, only when we end up in hot water over doing badly that questers complain about how Council gets on their case. Funny how that works, innit?