Newport City Council was thrown a “hospital pass” when handed responsibility for dealing with controversial speed limit changes, its leader has said.