So first of all, in synthesis a double spend occurs when a transaction X that sends founds from A to B is added to the longer chain, and after its added, a miner mines 2 blocks in a row but without the transaction X: instead it adds a transaction X' in which the coins are sent from A to A', which is an address controlled by the same person.
If transaction X being moved from A to B is already in the longest chain and means it has gotten a least 1 confirmation, successfully mining the next two blocks doesn't invalidate that transaction. Transaction X will not appear in the next blocks, they just push it deeper into the chain.
Unconfirmed transactions go into mempools not the blockchain.
The incentive
Miners who support your double spending will see an extremely high profit due to your high transaction fee. Also consider that you may not be the only one trying to double spend, so miners could collect all of these high fees on the fake transactions compared to what they could gain remaining honest building on top of the longer chain with honest transactions.
This is not feasible, from your analogy you are the one mining the blocks which double spend the transaction, this means there is no incentive for other miners. A one time ridiculous fee is not an incentive to build a chain with more PoW.
All of these doesn't matter cause the initial transaction X was already confirmed. 51% attack does not allow you manipulate older transactions.
There are cases in which users may want to roll back a transaction, for instance if you send money to the wrong address, or you regret your decision of spending that money, i think that's OK, and the network should provide users a way to do such a thing.
That is centralization which is not how Bitcoin works.