Why blockchain TPS numbers often collapse in the real world

bitcoin
Bitcoin (BTC) $ 86,402.00
ethereum
Ethereum (ETH) $ 2,746.88
tether
Tether (USDT) $ 0.999953
bnb
BNB (BNB) $ 788.38
xrp
XRP (XRP) $ 1.58
solana
Solana (SOL) $ 117.43
dogecoin
Dogecoin (DOGE) $ 0.100156
chainlink
Chainlink (LINK) $ 13.05
shiba-inu
Shiba Inu (SHIB) $ 0.000006
nexo
NEXO (NEXO) $ 0.88645
enjincoin
Enjin Coin (ENJ) $ 0.0284
cardano
Cardano (ADA) $ 0.252163