That's why self driving is the future. Need a mahoosive car to go to the airport - done. Need a small car to nip to the shops or pick the kids up from school? No problem. In the meantime, people will buy cars that match their use cases. For the majority of us that's an SUV or family type car.Most people need 1 or 2 seaters with some luggage space and maybe occasional access to a larger vehicle.
Much smaller, adequate performance EV vehicles surely must be the way forward.