when it comes to 51% attack it is always about cost and partly about the reward. the act of reversing a block is not profitable at all, in fact it would cost a lot of money. and it doesn't do anything since the same transactions that were in the confirmed block would either be in the new block or another block after it. it must be accompanied with an actual double spend with an amount equal to the cost of the attack to justify it. such high valued transactions will always demand more than 6 confirmation in which case the cost of the attack grows significantly more.
This is a bit complicated to understand and I've read few articles to understand the concept.
As far as I understood, 51% attack is a scenario wherein a group of miners owns more than 50% of the overall networks' hashing power which gives them the ability to
double spend and to
prevent the incoming transactions to be confirmed.
But how can attackers benefit from this type of malicious intent if they need to spend more of their resources such as buying high end mining equipment like the
Antminer S17 while the global hash rate they need to overcome is currently increasing (more miners)? They'll just suffer a greater financial loss. LOL
Furthermore, if there is an increasing number of miners in the bitcoin network then the possibility of conducting 51% attack is nearly impossible compare to the old days when the bitcoin is starting at an early age where no one is interested in mining.