What a confirmation actually is
Your tx sits in the mempool until a miner bundles it into a block — that's confirmation #1. Every block stacked on top after that is another confirmation. Platforms wait for a threshold before crediting funds because rolling back a tx gets exponentially harder the deeper it's buried.
There is probability of reversibility of transactions, and a more confirmation one transaction has, the less risk of reversibility as well as a more expensive cost for attackers to do that.
The chapter
The blockchain in Mastering Bitcoin book has very detailed explanation about blockchain and confirmations, their roles for transactions on a blockchain.
https://github.com/bitcoinbook/bitcoinbook/blob/develop/ch11_blockchain.adocOne way to think about the blockchain is like layers in a geological formation, or glacier core sample. The surface layers might change with the seasons, or even be blown away before they have time to settle. But once you go a few inches deep, geological layers become more and more stable. By the time you look a few hundred feet down, you are looking at a snapshot of the past that has remained undisturbed for millions of years. In the blockchain, the most recent few blocks might be revised if there is a chain reorganization due to a fork. The top six blocks are like a few inches of topsoil. But once you go more deeply into the blockchain, beyond six blocks, blocks are less and less likely to change. After 100 blocks back there is so much stability that the coinbase transaction—the transaction containing the reward in bitcoin for creating a new block—can be spent. While the protocol always allows a chain to be undone by a longer chain and while the possibility of any block being reversed always exists, the probability of such an event decreases as time passes until it becomes infinitesimal.
BTC: ~10 min/block, most platforms now require 1-3 confirmations (down from the old 6-conf standard) → ~10-60 min depending on threshold
Bitcoin is a strongest and most secure blockchain so if you want to have best security for your transactions and funds, choose Bitcoin blockchain.
https://howmanyconfs.com/How many Bitcoin confirmations is enough?
https://blog.lopp.net/how-many-bitcoin-confirmations-is-enough/Bitcoin confirmations risk calculator
https://jlopp.github.io/bitcoin-confirmation-risk-calculator/