Most expensive primary school in Wales approved for closure