Actually, it is already dropped by the mempool I can't see the transaction he made on block hair so my guess is this transaction is already rejected by the mempool.
Now, it propagated again.
Those nodes that dropped it from their mempool for being way below their maxmempool must have accepted it back from nodes that kept it.
Will this transaction be confirmed in 1-2 years?

If you write your ideas, we will be informed.
Best regards.
It's opted-in for rbf,
If you're willing to bump the fee to at least 2140satoshi (
16.1sat/vB), it'll be accepted by ViaBTC's free accelerator.
That's about 554 satoshi to be deducted from the already small output
After that, it would only take about 10~60minutes or more to get a confirmation, until they mined a block.