Not sure if I can wait it out any longer as it has been 3 days since and considering the very low fee, I am not sure if it ever gets confirmed.
It will most probably get confirmed in the next 4 days. No need to freak out.
As said, your fee is so low the free accelerators will not handle your transaction.
Since I am a newbie to all this, I am 'afraid' to tinker with features like sending to another address I own, CPFP etc..
The only
real chance for "accelerating" is that
you send to yourself the funds from bc1q4c3llfzdqs97saf5kzqr28fjjq9zshhq4tu0xy or bc1q385fvgf0mka42y7k0a66tjj55k0wl0kd9fxkkl, whichever is yours.
It may need a bit of research to spend unconfirmed coins (and I use Electrum, I don't know how this is done with blockchain.com), so it's up to you: learn to act or learn patience.
I am more looking for a bitcoin miner like the sticky in this forum suggested and actually have it confirmed through a miner if this is possible.
Since it's not a life-or-death situation, I don't see a good reason a miner would give up a transaction with better fees to handle yours, but you can hope...
What happens to the funds if the transaction stays unconfirmed and is eventually dropped from the mempool? Will the funds be lost?
They will returned to your wallet, like the transaction never happened. Of course, the wallet may or may not know how to handle that, but you can always go for a smarter wallet if it's needed.
Again, stop worrying for no good reason.