Stargate Universe: Series Finale

Image via WikipediaStargate Universe: Gauntlet

Shows either end or the writers want an opportunity to make a movie a DVD in the future so the give a cop-out of an ending.  (Sopranos)

Stargate Universe had no real ending. Instead everyone gets frozen on their way to an unknown galaxy while one character gets left on in the cold, not literally. The one guy is smart enough to survive but has 2 weeks until the air runs out. From what I understand the power went out after 2 weeks and we see him staring out the window with a smirk.

Did he fail? Did he succeed and is taking a victory lap? Did he find another option?
Did I waste my time watching this show?