A Sinn Féin surge in Dublin City has left a bruised Labour party with just a fraction of its seats and the loss of some of its high-profile councillors.