Jim, here is a closer parallel in 19th Century USA.
Parts of Mexico were made parts of USA.
The people in those states now are mostly happy with that, but if the whole of Mexico got to vote on it, there would be a few less of those united states.

Do you think that would be sensible?

You have not commented on the evidence that Ireland would not vote for unification anyway.