Ideally it is 14 days by default but there some conditions that could still keep it there more than that time. One is if the wallet or sender doesn’t continually rebroadcast the transaction, but if they do then it will certainly take more time. Secondly is since node’s mempools receives transaction in different Time it will also take different Time to drop it and also the size of the pools are different and as such some will keep it beyond that time
Every node which is connected to the network will receive the transaction within, at most, a minute or two of each other, so this will make no difference to OP.
As Charles-Tim has pointed out, the transaction is already older than the default expiry time, and pays a fee lower than the default purge limit. All default nodes will have dropped it already. And yet, we can still see it on almost any block explorer that you check. There are more and more nodes running with much larger limits than the default, so you can no longer rely on transactions being dropped at all.
Instead, given that full RBF is now commonplace, the sender of this transaction could easily replace it with a higher fee paying transaction, even though it is not opted in to RBF.
The change address belongs to CoinSpot, so I assume they are the ones who sent the transaction. The only thing OP can do is contact them and request they replace the transaction.