This has affected me and caused me a sleepless night because the said money wasn't for me but the entire family for upkeep during this trial moment. I am regretting my loss because the remaining members of the family aren't aware of this loss.
This is where the problem is coming from, you used money that wasn't meant for gambling to gamble and now you can't get over the fact you have lost that money. You should thank your stars you didn't have more funds on you as that would had tempted you to use it in trying to recover your loss which will only end in more losses.
Although the act you display is associated with gambling addict I won't say you're one yet but you have to be cautious because assuming you're not an addict you're getting there with such behavior of yours. Always allocate funds to be used for your bets that's the best way to checkmate overspending or using funds that aren't meant for gambling to gamble.
You are right, that's the problem with people when they have excess or money on hand they will use it to gamble even though it's for their family, it only means that you don't have self-control and definitely will cause you sleep difficulty. Too much stressed or depression will cause you to have sleep issues because of the losses. Unhealthy gambling is harmful in many ways, from mental, emotional to physical health. People with this kind of addiction either minor or major may experience a lot of difficulties on your body.
Better try to have self-control, limitations and focus on your purpose. Don't just waste money on gambling because even though it will double your money remember it would make your money gone just a snap.