I watched this last night (tivo), and was surprised how much fun I found it to be. I never watched a single episode of SG-1 because I don't like Richard Dean Anderson, thus I can't compare the two.
I just checked the SCIfi Channel web-site and it does not appear that it will be back on...