You should also note that if the majority of people in Northern Ireland wanted to be part of the Republic they would actually vote that way at any of the relevant elections.

Having said that, the minority community in NI had been treated pretty awfully over the years so I think the current situation is a pretty decent compromise.