The closest relationship that can marry in the game are two first cousins, once removed.
Another way to think of it is that your sim can marry their great-uncle's child, or that they can marry their first cousin's child.
So no, the hypothetical great-great-aunt cannot marry back into the family.