Also blockchain.info is showing all transaction even with extremely low fees.
This is not true, as the above transaction proves.
My advice is to abandon transaction and move to better wallet
There is no better wallet than Bitcoin Core. It's the original and gives you full control. The fee problem isn't caused by Bitcoin Core, it's a result of the user being in full control.
What is the best way to abandon the transaction with bitcoin core?
Let me quote myself to answer this:
You can manually remove the transactions from Bitcoin Core:
-Exit Bitcoin Core
-Backup your wallet.dat, even though you should have a backup already, make another backup
-Start Bitcoin Core from a command prompt with options -zapwallettxes -rescan (if you're using a pruned wallet, you can't use this)
Depending on your hardware, it will take a few hours to rescan. After this, your transactions should be gone, but Bitcoin Core might pick them up from mempool again. In that case just wait for it to drop again.
Full description of the commands:
-zapwallettxes=
Delete all wallet transactions and only recover those parts of the
blockchain through -rescan on startup (1 = keep tx meta data e.g.
account owner and payment request information, 2 = drop tx meta
data)
-rescan
Rescan the block chain for missing wallet transactions on startup