The portrayal of sexism that Samantha Carter and other female military members face is actually an overall positive part of the shows writing. They highlight how problematic it is and Dr. Samantha Carter continues to rise through the ranks as her accomplishments are recognized by the good leadership that she serves with. She is far from a token character and she provides some of the most significant contributions to the team.

So that issue you have does get better. I would argue that the writing overall is rather progressive for the time.

Feel free to not like the show though. It can be a bit hokey. Not everyone enjoys cheesy sci-fi.