My background is that I've cycled my whole life, all of childhood in rain and snow and later I've cycled for a few years in a big city. But I started to use it less and less, and now it's just parked and unused. And the reason is that there's always a better alternative. If the weather is nice, I drive an electric moped, it's not noisy or polluting, and it doesn't take up much space. And it's so so much better than cycling, I arrive much quicker and with more energy anywhere I go, and I can use the whole existing road network. And when the weather is bad, obviously public transport wins. I think the future is electric and self driving vehicles, not cycling, and being forced to propel yourself manually like that for basic transportation has no place in a modern world except for enjoyment, and this can be done in designated areas.
If you just want to avoid cars and have a more leisurely space, why not designate pedestrian zones like traditionally done in city centers, and use the space for cafés, market stands etc.