People will resist giving up cars in areas with crappy weather, but I could see this working in many US cities west/south currently choked with traffic.
And people will claim crappy weather as an excuse almost completely independent of weather. The closest things to cities without any bad weather would have to be San Diego and Los Angeles, and the legions of cars there are just as endless as elsewhere.