usually it takes about 2weeks, 14 days and a total of 336 hours for a transaction to be purged and dropped from the mempool. A possible reason for any further delay before a transaction is dropped, might be due to the time when some full node had received your transaction.
On Bitcoin Core, it is 14 days, but some node runners may not leave it as default but change it to a longer period. You can change it also on Bitcoin Core. That is why some nodes will also retain the transaction after 14 days.
Thanks for the informative reply, I'll try that if the tx doesn't purge soon
The purging is 4.45 sat/vbyte right now and you said your transaction is 4.4 sat/vbyte. Some node runners can also edit the purging rate to a higher one. Do what I told you to do and you will be able to spend your coins in a new transaction. Your wallet is the reason you are not able to spend the coin in a new transaction.