It was a pilot! All character development and setting up the story. Very few pilots are considered great episodes! I'll give it a few more weeks. Saying you hate it after the pilot sounds to me like you hated it before you even watched it. Sorry, but I won't take any opinions of how good it "is" based ojn this one episode.
As for predictions ... I think they will return to the ship and the ship will keep trying to fix itself for the entire first season. That is why they had that timer on the wall. They will not be able to change how long it stays in one place for a while making the drama of a limited amount of time at each planet a plot line. It also allows them to leave characters behind and have to find them later. So many things they can do with such a uncontrollable limitation!
Now ... the real question is who will be the arch enemy that is unstoppable until the second or third season when they meet a more powerful unstoppable arch villain!
All of what your saying is the problem with the show! Been there done that, I am tired of them being out gunned at the start and then by season 3 being able to dispatch the enemy with great ease. The pilot is less than thrilling because it smacks of Atlantis, the ship has major structural problems, Atlantis had major structural problems, the ship is empty, Atlantis was empty. They are cutoff, Atlantis was cutoff.
It would have been so cool if they had gotten to the ship and found lots of cryo freezed ancients just waiting to be revived, maybe Ancients with a fresh perspective like they dont want to asend, they want to explore in human form, they like humans and want to learn more about the milkyway and what has happened since they have been gone.
Who knows anything new, just not the same old same old.