since if I remember the episode (McKay and Mrs. Miller) correctly,the Mensaverse Atlantis is back in touch with their Earth,

Ow, ow, fuck, I didn't think of that. You're right, that takes a lot away from the hopefulness of the ending. I think I'm going to imagine that this is an AU of the Mensaverse where Atlantis ends up seceding from Earth.