I think it would be a major flop and kill the SG franchise for good
As a franchise, Stargate is
dead. All three television series were cancelled; the last series, Stargate Universe
, had ratings so low it ended after just two seasons (on a cliffhanger, no less). The straight-to-DVD market dried up just as the franchise began to enter it, resulting in all further proposed DVD movies being cancelled.
Personally, I think Stargate slowly fell to pieces after the end of SG-1 season 8/SG-A season 1, but even if you like what happened after that point, you have to realize that the franchise probably won't be continued in that iteration going forward.