The only reason I would disclose my seed phrase to another person is for hereditary purposes. Even then, the thought of sharing such vital information still scares me. What if the person I entrust it to misplaces it or shows it to someone else? What if they take advantage of that privilege and steal from me before I die, leaving me with nothing?
On the other hand, death is inevitable and often unpredictable. I do not want to pass away leaving nothing for my wife and children, forcing them to struggle when I have something that could change their financial situation.
However, this is a risk that must be taken. For that reason, the most trusted person I know is my spouse. I am confident that she can keep my seed phrase safe and manage everything well, even in my absence. This is a risk worth taking.
Every method has risks, no method is absolutely perfect, the only difference when making a choice is what kind of risks we accept and trade off. Like you, I don't deny that revealing the seed phrase to your wife/relatives is risky but it's worth the trade-off. Because I don't want my life's work and effort to go down the drain if something unexpected happens to me and my children don't inherit anything. I don't want my children to live in poverty just because of my selfishness in not trusting anyone, not even their mother, who would take care of them if I died.
You are right, that risk is worth taking.