Just checked Airalo and they have 3gb for $10.50 usd! That’s like 9.50€ or something and Airalo always seems to have a 15% off coupon (maybe first order only?). They also have larger plans. I am going to switch over as soon as I run out of data on my Andorra Telecom plan.
Last time I was in the UK ended up walking into a Vodafone shop and got a physical SIM and 30 day 20GB pay as you go plan for £10. That would cost $74 on Airalo.
I'm looking forward to eSIM being more widely supported as its definitely more convenient. In the last year most US carriers have started offering it on their PAYG plans.
On the other hand, if you are a regular visitor to a country, or you are meeting a local who can hook you up, or you are staying for a while, then it may be worth getting a local SIM. Some countries make it easy, others make it difficult. In UK for example it’s very easy to get a SIM and the local prices are about half of Airalo (which doesn’t seem to offer an unlimited data plan).
Also, travelers from Western countries might not really be ecstatic about paying for paying $$ for something that comes with zero upside to physical SIM.
It's subjective, I'm sure there's still people buying DVDs, but you can't say that there's "zero upside"