> and people only pivoted to that when it became undeniable that Bitcoin was not fit for its original intended purpose.
These days it is likely(1) that the majority of Bitcoin transactions by number(2) are being done via the layer 2 system Lightning, which does have nearly instant payments and low fees. Transactions via Lightning are not recorded on the blockchain, even though you can easily hold funds in a non-custodial way.
I happen to be in El Salvador at the moment, and with the exception of the Chivo Bitcoin ATMs run by the government, every single vendor selling things for Bitcoin has accepted Lightning.
1) It's hard to know for sure, as Lightning transactions have quite good privacy, so it's difficult to get estimates of how many there are in total. But decent lower-bound estimates exist: https://bitcoinmagazine.com/markets/lightning-network-sees-r...
2) Of course, by value it's very likely that on-chain transactions dominate, as there are lots of very high value, multi-million+, transactions out there.