You need to bear with it through the usual S1 growing pains
By today's standards it's almost unbearably 90s, especially during the first season (IMO)
It really does get great.
It made me cry at least a few times.
SG-1 was a great mixture of comedy and drama in sci-fi IMO, and while it's not my very favorite franchise, it's easily top 10 for me. If you haven't seen it before it's worth your time for sure!