The council leader said that he “couldn’t think of anything worse”, but one councillor accused members of being “anti-cycling” and called the decision disappointing