In the future, if I pay a coffee with a very low fee, will it ever be paid?
No, ofc not.

In future, if the fees are insignificant, there will be a lot of transactions and miners will get the proper rewards for their work by all those small fees together.

New blocks are coming with new transactions every 10 minutes. Any transaction with fee superior to 1sat/byte will eventually gets confirmed.