Meh. Just watch it in order. It is what it is.
Can't get excited by the trailer. Somehow it seems like trying to do "E.T. 2" or something. Even with JMS involved, it feels like tacking something on to something that was nicely wrapped up. The LotR prequel, for example. And somehow, my brain has shifted to where animated is like the straight to video version of live action. I know none of that is logical, but it's the way I'm feeling.
As far as the original series, it would be neat to see it get the "Star Trek: Remastered" treatment, although probably not as rewarding, because all the FX shots were already fairly neat. You could certainly make them look less CGI with modern tech, but that wouldn't add that much and might actually be more jarring, since you can't really change the physical sets and costuming.
As far as SG-1. That one, the producers started running out of things to do and kept wanting to do the Star Trek model and move to a series of films, so from about Season 4 they keep setting up the season finale in a way that lends to moving to feature films and then MGM just renewing the series because it was a cash cow so they have to extend the storyline for another season. For me, the story ends with the big battle over Antarctica. The show loses me after that so I just pretend that's the finale. [EDIT] And interestingly, for as much as I loved the show when it was on, it just isn't as rewatchable for me as classic 'Trek. Dunno why.