To be completely fair, is the network not working as advertised? Yes, it is.
Why do you think it's not working as "advertised", you can still transfer on permissionless bases despite the high fees,
BTC was never advertised for being both cheap and permissionless, so practically, the network still works in the same manner it was on day 1, blocksize is limited, people outbid each other to get transactions confirmed, nothing has changed except for the fact that people are now willing to pay more.
Is this a bad thing for many people? it is, but that doesn't mean
BTC has changed. no, we can blame Ordinals and BRC-20, but if we look at the numbers
May 08 > 41.4% of transactions were non-Ordinals
May 07 > 34.2% of transactions were non-Ordinals
May 06> 46% of transactions were non-Ordinals
May 05> 64.9% of transactions were non-Ordinals
There is no doubt that these Oridnals caused the initial spike, but the data shows that there are many people willing to pay high fees to move their
BTC around, they are okay with paying 1 sat if they could get away with that, but when it's 500 sats/Vbyte that doesn't seem to stop them.
Which why I strongly agree with your following statement:
This is actually a good real-life example that Bitcoin's 1st layer in its current form isn't nearly ready to be a day-to-day payment method. Just imagine if there were no Ordinals and you substitute those transactions for normal BTC transactions of millions of new people who have started using BTC for everyday payments. That's how it would look on the mainnet. Half a million of unconfirmed transactions.
Even without Ordinals, at some point in the future, we will have people transacting millions of dollars whereby paying $20 fees to have a final settlement of 10M on the most secured blockchain on the planet earth is considered dirt cheap, where the plebs like us who want to send $200 worth of
BTC find it stupid to pay 10% in fees.
eventually, the "weaker" hands will have to move to L2 solutions, the only reason why the usage of LN has not been increasing drastically is that people could still transact with 1-2 sats, when they can no longer do that, they will be forced to use things like LN.