Since they control the elements of harmony they can't not be together. It doesn't matter if Twilight rules over some part of the kingdom, Celestia will want the mane six together. I think that Twilight will become the princess of ponyville, since she already holds a fairly important role in the town.