I don't think we'll be seeing many Ha'taks or terran cruisers in this show. And since the battle happened entirely off-screen, we don't know what happened there.
With the Asgard beam cannons even several Ha'taks wouldn't be a match for a terran cruiser.
I thought Atlantis would be horrible because it had McKay as a regular (I hated him in his SG-1 appearances), but he ended up, surprisingly, being entertaining.
Of the characters that were there from start to finish, he was absolutly my favorite. After all, who else can blow up a star system and get away with it?

But could have concluded the pilot episode a small bit better.
I found the jumping back and forth from past to present during the first half to be really confusing.
I do feel a Star Trek voyager / BSG mix and match going on here though
It seems to be doing right everything Voyager did wrong, especially characterization. But sometimes I think maybe it is too much like BSG, the commander seemed WWWWAAAAAYYYYY too much like Adama, even looks and vaguely sounds something like season 1 Adama.