Kaishu,
Thanks for posting that data again, its very valuable to help understand how we use oil now. You are correct that in an emergency(either long or short) we could drive a lot less than we do now. I live only 1Km from shops, but usually drive, because my arms tend to stretch carrying home dog food, milk, potatoes,wine, beer etc. I wouldn't stop driving these short trips even if petrol was $3/L, because it really doesn't use that much. Now commuting 15 Km to work by train without any transfers, and 1Km walk at each end, that's easy. In an emergency though I could easily buy smaller amounts and shop more often or go by car less frequently and buy a freezer or a larger fridge.
Social activities often involve weekend and late night trips and usually 2 or more in the vehicle, so again mass-transit not a good option. Sydney trains stop running between 1-4 am ? each morning.
Voluntary activities such as dropping off groceries, taking elderly shopping, picking up kids for soccer; if mass-transit worked for these trips wouldn't need be volunteering.
So I really see the best role of mass-transit to replace single passenger trips, over longer distances such as commuting to work and of course interstate trips between capital cities.
You are correct that some cities are designed to work on mass-transit, such as Paris, Venice, London and other European capital cities that were build by great empires, well before cars. We could re-build our cities to be like that buts its going to take several life-times, and most of our mineral wealth, meanwhile if BEV's become widely available, a lot of people are going to use them for that 65% of "non-essential" trips including those "walkable" less than 3km trips that Europeans drive now even though they have a good mass-transit system.

I live only 1Km from shops, but usually drive, because my arms tend to stretch carrying home dog food, milk, potatoes,wine, beer etc.

You're in luck! Just yesterday someone invented a brilliant device which puts the weight on your back instead of your hands and arms.

And if you are infirm, there's also,

Every day an 84 year old man with arthritis squeaks past my house with a similar trolley/walking frame, walking 1.6km to the shops and 1.6km back. If he can manage it so can you.

I wouldn't stop driving these short trips even if petrol was $3/L, because it really doesn't use that much

I wouldn't stop stabbing you with a pencil even if you said "ow" really loudly, because it really doesn't injure you that much.

With resource depletion and climate change as strong threats to the quality of life of the world and generations to come, every little bit counts.

I leave casual dismissal of your other excuses for driving to other more patient people.