When Sin is destroyed, Yevon possesses the nearest Aeon That aeon is made into a new Sin.

If there is no Aeon to possess, I have no idea what happens to him.