Do not let your transaction to remian unconfirmed if you do not want to, make use of wallets that support opt-in RBF to pump the fee. You can read this:
Bitcoin open source wallets that support replace-by-fee (RBF)By default, on Bitcoin Core, the transaction should leave the mempool in two weeks. But some nodes can differ, while node runners can change the days by themselves.
So likely expect the transaction to leave the mempool in a way that you can rebroadcast the transaction. But I would not totally agree on that because your wallet may be rebroadcasting the transaction, or the transaction do not leave all nodes.
You may just have to wait until the mempool is no more congested and the fee priority decreases, or you can use CPFP, but the best to unstuck such transaction is to pump the fee if flagged to support RBF.
Blockchain explorers are like nodes run by third parties, so if the transaction leave the node that the blockchain explorer uses, you will no more see the transaction on the particular blockchain explorer.