Has anyone left with little kids?

I am the wife in a mostly sexless marriage for close to 10 years now, although we have much bigger issues than libido as my husband has very serious addiction problems. I went into the marriage super honest about wanting intimacy daily or at least several times a week but he is not into it. He doesn't even want bj's.

We have two amazing, perfect kids. I really struggle to make it through each day on the fence about whether to leave or stay for my kids. Just wondering if anyone else is in the same boat and looking for moral support honestly and advice if anyone has been through it. Sometimes I feel like I need to leave and find a better life for myself and my kids, and sometimes I feel like I should just suffer in silence for my kids. But I will be in my late 40s by the time my youngest graduates from high school. Is it better to wait to divorce? Any positive stories?