Residents claim “jumped-up, arrogant” cyclists will cause “carnage at the expense of pedestrians” as controversial cycling ban to finally be lifted on shopping street to “improve choice of routes”