I did test-drive a fairly new Nissan Leaf in my search, and really liked it as a car, but as I said, I've gone with a diesel again for this next car, because the price vs. what I need from a car wasn't there yet...
As this thread shows, there's not going to be a one-size solution. In many places in the UK, public transport is laughable: poorly designed, thinly distributed, and expensive. For urban and suburban areas, that's an obvious point of investment. For rural areas, a bus that comes only a few times a week is as useless as a chocolate teapot. In my context (on the edge of a city, fit and able to ride an e-bike, but needing to drive into the country on an irregular but fairly frequent basis, and needing towing and transport capacity), my particular combo of e-bike and diesel 4x4 makes sense for now. Realistically, I can replace about half my car journeys with the bike, and I'm trying to do that now.
Our public transit system is a radiating one: most routes go into the city centre. Trying to get from point A on the edge to point B on the edge means going into the centre first, and then back out. There's a chapter in "Invisible Women" that talks about that sort of transit design, and other options which are much more helpful to the sorts of trips that aren't an in-out commute: it's a fascinating read. For me, trying to switch to public transit would mean that I would need to make a 2-hour bus journey and then walk for an hour, for a daily trip that takes 15 mins by car or 30 mins by bike. So 6 hours round trip, vs. 30 mins to one hour round trip: not gonna happen! Yet when I lived in a big city that has a more grid-like system with high frequency, I felt no need at all for a car, and in such a situation, I can see that an initiative of cheap short-term car hires for occasional trips would be really useful to many people.
My mother, who lives in a suburb of a sprawling medium-sized city, is currently thinking about giving up her car. It's got us thinking about what options exist that are useful to her. The nearest bus stop is 10 minutes away, the frequency isn't great, and the system is radiating, so it would take long and complicated journeys with potentially a lot of walking to get to her usual haunts. This is really impractical in winter, as she lives in a country with long, cold, snowy winters. Taxis aren't cheap, and while it would be fine to take a taxi for her weekly shop, we're worried that she'll become more or less housebound. It's hard right now to think of a workable alternative to the car, without moving house.