Then you say that the debt is caused by the husband, so how is it caused? The investment loss is still some bad hobbies such as gambling. How to plug this gap is something you need to communicate with your husband. If the main source of debt can be basically controlled, there is no need for divorce. If your husband insists on the original lifestyle and you can't stand it at all, then divorce is the only choice.
You should consider selling your own house. If it is really necessary, give buyers a really attractive price to attract buyers to sell quickly. If not, obviously you'd better negotiate the details of the transaction slowly. In addition, I don't want you to try to get rid of the current predicament by praying to God, let alone obsess about the result of the lottery. If you can calm your emotions, patiently sort out the relationship with your husband, and have a general understanding of the flow of funds at home, there is a way out of the predicament.
Besides, your husband should have a better way to deal with the current predicament than you. If he has a way, you are just being romantic when you are in a hurry. If your husband is not satisfied with your solution, it will aggravate the contradiction between you and your husband. If he really can't help it, a qualified husband should communicate with you on the disposal of important family property such as selling a house and ask for your advice. If your husband doesn't want to repay these debts at all, then I advise you to get a divorce as soon as possible: a man who can't even manage his own finances well will only drag down the whole family.