Indeed. I don't think I've ever paid significantly more than €12,000 for a car - and the last couple I bought new.
Clearly for some people they'd be useful for short-distance commuting or shopping, but generally I'd cycle or get the bus (well, pre-pandemic: let's assume it won't last forever).
I tend to use my car for somewhat longer journeys where public transport isn't an option and for bulky shopping. Don't think either of these would be too useful on a 100-mile round trip on the motorway or on an expedition to Ikea.
Finding a niche that will meet the needs of sufficient people without their needing a second vehicle is going to be quite tough, I suspect.
Having said that, I don't need a car every day and I'd happily rent a vehicle that was appropriate for my needs on that specific day, but I suspect the logistics of availability mean that's unlikely ever to be particularly convenient without planning your life weeks ahead.