I don't believe it's a good idea to give your private keys or bitcoin keys to someone close to you while you are still healthy and young; doing so is a risky and easy way to make your life miserable because your bitcoin will be gone as soon as you do so to your son, wife, or any other person you truly trust, because these days, close friends and family members have the power to hurt you more than anyone else, and when it comes to wealth, it's very risky to do so, in my view, while you are still healthy, don't give your relatives access to your bitcoin private keys.
I agree with you on that, I think it is not a very bright idea to give access to your funds to someone no matter how much you trust them. If you ask me, there is only one person in the whole wide world that I trust more than myself and that is my mother, and she knows nothing about technology and everything, especially Bitcoin, and I think that is the case with most of us.
So basically, it is better if we don't give anyone access, but we should write a will and describe in it where we have kept the private keys, etc. So that when the will is read after we are dead, the funds are not wasted and accessed.