Frankly I don't mind fictionalizing the military to show them as idealistic, accountable, intelligent, and egalitarian. It's what they should be, and it sets an example that both gives an ideal for the real military to strive towards, and it stands in contrast to the real world issues with the actual military, highlighting the ways in which they come short or behave counter to that ideal example.

Personally I want more people that are going to enter the military to want a military like SG1 than to want a military that does what it actually has done historically. We shouldn't whitewash reality, absolutely, but that doesnt mean we can't have better examples in a sci-fi world.