A moment means a very short period of time, like a few seconds. So Auntie Flip is saying that he may be tired now, but in a few seconds he will not be, because of the "surprise" she has. And no, "You wont be a moment" doesn't make sense and is not the same.