It’s not useless. I’ve deleted over 10k of my notes. Sure they probably exist on relays somewhere, but they’re not easy to access. I challenge you to see how many of my notes prior to Dec 2023 that you can find.

Even if a NIP were created to signal that your private keys were compromised, people would just make clients and relays that ignore this NIP.