I think it's at the bottom of the list because the mining fee is so low.
Will this transaction be confirmed in 1-2 years?

As Zaguru12 said, it will be dropped by the nodes' mempools. It generally takes 2 weeks to be dropped if the fees don't fall below your fee rate.