I really hope you stop seeing this situation as your husband needs to do a better job of hiding the pills. This is your responsibility and you won't get better until you take responsibility for your actions.
And, I think it's more important to have your children cared for safely, than worrying about whether family members will be judgemental. Don't worry about what they think. Do the right thing for your children.
Please take action and stay safe.