I remember hearing a story about an author who asked his best friend to burn his written works upon his death. But when the time came the friend did not burn anything. Instead he published two books after the author's death.
https://teachprivacy.com/frank-kafkas-last-wishes/
This is a controversial story. Should the author's wishes have been honored? What about the two books which went on to receive much acclaim?
I think the only way to know your wishes will be honored is to take care of it yourself.