The hard lesson here is that there is no delete option for online content. If you upload, the data is out there. Or do you think that twitter has no record of your "deleted" tweets?
Similarly on Nostr you could easily delete from your own relay, or have some relays that offer a "delete" option... but other relays will not.
imho it's better to not fool ourselves and learn the lesson that we have to think before we post. Nyms, multiple npubs, other privacy options will have to do..