Activists and readers opposed the Bristol plan and won. Other councils should take note, and everyone should take heart, says Guardian columnist Frances Ryan