Thank you for your comprehensive answer. How do I delete a transaction at all until it is confirmed and if it is RBF?
You can't delete a transaction once it's broadcasted. You either wait untill it's confirmed or untill most nodes dropped it from their mempool, or you bump the fee (create a new transaction to replace the previous one).