The thing is, there is no central mempool, every nodes with full blockchain that verify bitcoin trasactions have its own mempool, and these nodes communicate with other nodes and pass blocks mined and transactions already confirmed across for verification in which mempools are also updated. You transaction might have left some mempool, but that does not mean it is not still included in other mempools. Even, that is why there can be transactions that is already dropped and yet later confirmed after 14 days, the reason to rebroadcast exactly the same input that was dropped. In your case, the transaction has not being dropped by most mempool.
Which wallet did you send the transaction to? If you are able to spend unconfirmed transaction on the wallet, you can send to another address on your same wallet using input from the unconfirmed transaction. If high fee is used, the transactions will be confirmed earlier.
Thank you for the swift response.
While yes, I am familiar with the decentralised nature of mempools to an extent, so I was simply referring to the collective multitude of them.
As for my destination wallet, it is Coinbase wallet for Android, and I do not have the ability to spend unconfirmed funds.
It is not a matter of utmost urgency, but I do not want to simply leave the funds in limbo indefinitely. As an experienced user, do you think I could expect the transaction to be dropped in the coming days or weeks, or should I seek another avenue to resolve the situation?
All the best.