Councillors in Mid and East Antrim have voted to change the name of a road called Prince Andrew Way in Carrickfergus.