An excruciating moment took place in the second season finale - where Aidan chose his children over Carrie - but suggested reigniting their romance in five years