e.g. if a block costs ~70k USD of electricity and you accept a tx for more than 210k USD after 6 conf then if the sender is a purely self interested actor in a perfect market their rational decision would be to spend a bit more than 210k USD in electricity to mine 7 blocks.
Obviously this is a completely idealized market where you can purchase mining power to fork at will.
But the end result is that the more electricity burned the larger tx you can trust with a lower amount of confirmations. In ~7 years we'll see block rewards drop to ~3 BTC. By that point if we don't have tx fees that compensate then we'll see a large drop in hash rate. If the size of the blocks doesn't increase, the size of a tx decrease or something else we will either see the security drop quite a bit or the cost of a on the chain tx increase dramatically.