It will eventually fall out of most nodes that have default settings:
Even now it's not in blockchair
https://blockchair.com/bitcoin/transaction/3a88b7e9edb449562f6a62e05e763d3890b7ffb52b5e8d0c21a19a2f1b2bd042

The catch is most pools & explorers keep TX for a very long time since the pools want to have the chance to mine whatever they can and the explorers tend to want to display as much info as possible.
Other then paying for acceleration it's just a waiting game.

But as LoyceV said it really could stay there for a looooog time:

Do you know from what wallet the sender sent it from?

-Dave

If it doesnt drop does it stay there forever or something just sitting there as a transaction in the void type of thing?

There is one legit accelerator that will actually confirm your tx and not just rebroadcast, and that it is ViaBTC!
But on a simulation for your tx they ask for $130 so, looking at your $190 worth of BTC tx, I doubt it is worth it.

So, the usual question,are you in control of any of those wallets, or are they custodial wallets? Once we know how that looks we can think of what other options you have, that is if you have any!

Since it is cash app you are receiving into them from your end you cannot do anything because it is not a non-custodian wallet that allows transaction bumping. The only way is if the transaction is not from an exchange and the wallet of the sender can actually bump the transaction you can simply ask him to or better still double spend your the transaction again from there but if it is an exchange sorry nothing can be done, you may have too wait and hope they don’t continue to rebroadcast the transaction with such low fees.