the absolute worst case the unconfirmed transaction will simply disappear from the network, as if it never happened. Keep in mind that the your sats never actually leave your wallet. Itβs just that your wallet doesnβt show them as βavailableβ, but you still have options like RBF and CPFP to get your transaction confirmed with higher fees, or to βcancelβ your transaction by spending the same coins onto another address with a higher fee.
A transaction with very low fee rate might also disappear from the network if the mempool goes over 300MB in size, because by default a Bitcoin Core node will purge transactions from its internal mempool, starting with the lowest fee rates first, while increasing its minimum acceptable fee rates that it will broadcast further. even if the transaction has been forgotten by most nodes and doesn't appear anymore on blockexplorers, it is still a valid transaction and might have stayed in the mempool of a node somewhere. So it's better to use one of the inputs in another transaction to invalidate the original, "stuck" transaction (otherwise you risk it to be re-broadcast and be confirmed when you already forgot about it).
read more https://bitcoin.stackexchange.com/questions/96068/what-if-the-mempool-exceeds-300-mb/96070#96070