It id because your transaction is still on the mempool unconfirmed.
you cant imagine that it cost 4 USD for instance to cancel a transaction and 1 USD to pump it, which is more preferable, then i realized that the transaction was not sent initially, therefore, no transaction sent and confirmed can be cancelled.
Canceling a transaction always requires higher fees than pumping it.In canceling a transaction, you change the output transactions to one of your wallet addresses, and you need to guarantee that the new transaction will be included in the next block to cancel the old transaction. Therefore, the fees must be higher than the previous transaction, while in the case of pumping old transaction. It does not matter whether the transaction is confirmed before or after pumping.
When replacing a transaction it doesn't have to be changing wallet address or using the same wallet address that you sent the coin but paying high fee will do the trick for the transaction to get included in the blockchain. There is a chance that it won't be included in the next block if the transaction fee isn't high enough. A transaction can't be cancelled as long as it is not purged from the mempool or not replaced by a new one. (I may be wrong and you are welcome to correct me).
Right. I would also do so, if the original transaction has not been flagged as RBF and I want to increase the chance of the second transaction being confirmed.
I don't have access to any data, but I don't think nodes that have not enabled full RBF yet are rare.
If RBF is not enabled then I think CPFP should be the other ways get it confirmed.