I would love to read about the psychology of why we may want those notes to be hidden from them before our death/injury.

Not sure you need psychology to figure it out: the notes may contain passwords to your accounts, confessions, and other things you're not comfortable sharing when you're alive.