Transaction failure is misleading. Here's a good thread explaining the details: https://twitter.com/0xMert_/status/1771700602629730795
tl;dr Users often submit transactions that attempt to arbitrage price discrepancies on-chain. But someone else fills the arb before them and so their transaction while successfully received will result in nothing happening. The transaction didn't fail though. Solana, your "decentralized server", successfully received the request.