Brexit has acted as a catalyst towards a border poll in Northern Ireland, escalating existing tensions and exposing political fault lines.