I wouldn't expect Stargate to be with us much longer.
Stargate SG-1 and Stargate Atlantis were both cancelled.
As for Stargate Universe, who can say? I haven't seen any episodes yet.
It looks like if we want a long term Stargate experience, we'd better start playing the upcoming multiplayer game.
Although, I am worried about what kind of people that will draw in. In order to prepare for Stargate Worlds, I played a similar game. And towards the end of my time, I was loathing some of the players with the vengence of a Incendiary Propellant Gun. Basically, bad players are drawn to mmos. The primary problem is people with no lives who are obsessed with being superior through PvP. If you don't PvP or even suggest that you are a "balanced" player (one who does both equally), they declare war on you. Then we have the XP leeches, people who get others to do all the hard work for them with no or minimal help from the leech. And then we have the flamers, those people ready to pick fights at the drop of a hat and actively go looking for or causing these fights.
I'm REALLY hoping these people don't show up in Stargate Worlds. Or if they do, they're banned really fast. Even though the game isn't active yet, the community is already established and it seems like a very nice one. It would be a shame for "outsiders" to come in and ruin that for their insane personal agendas.