I was wondering similar about the therapist. It's great that you feel comfortable with her, but I'm shocked that she hasn't been able to offer any insights into the issues you've described. That's just not good enough and is not a great reflection on her competency.
There is a fairly clear pattern that the rejection and de-valuing you experienced as a child has shaped your adult life and relationships. You seem to have the expectation that you're not worth very much and therefore don't really deserve to be treated that well. That your needs are not important, and that your role is to make other people happy by meeting their needs instead of your own.
I don't think it's that you attract users so much as that they see your vulnerability and target you.
I'd also observe that there is no such thing as a relationship that is abusive sometimes, or only occasionally. It might be that abuse has only escalated to the point where you noticed it and identified it as abuse on those times, but abuse is about a pattern of behaviour that will be threaded through the entire relationship. There's no such thing as an isolated incident when it comes to abuse.
You mention how your husband comes home every night and "takes things out on you", blames it on work, but then does nothing to change it. You do understand that work is just his excuse for mistreating you?
The fact that you describe him as being so into you in the beginning that you found it overwhelming is a huge red flag, as is your description of the relationship as "stormy". Combined with your other comments, it sounds like it has been abusive from day one. This will have added to your sense of being worn down and alone. He too will have targeted you for your vulnerability, and it's why his love bombing and early intensity were so effective and had such a hold over you.
It's not a great reflection of your therapist's training and experience that she hasn't identified this either. Abuse can be tricky to identify because it's about the dynamics and patterns rather than clearly defined single incidents. But professionals ought to have educated themselves on it and be able to identify it.
Leaving your (abusive) marriage doesn't mean opting for a life alone. It means giving yourself the chance to build relationships with people who value you and treat you right. It means modelling for your children that they should not accept being mistreated, downtrodden and made miserable by the people in their lives who claim to care about them. (Which is currently what they see in the way your husband treats you and them).
I think you need to consider finding a different therapist or psychologist who has training and experience in the dynamics of abuse, who will be able to help you make sense of what happened in your childhood and how it's shaped the way you experience the world and view yourself now, and also help you to unravel what has happened in your marriage and just how abusive it really is.
If you stay with him it will only get inexorably worse over time. Do you want that future for you and your children?
Leaving is a process, it is hard, but until you do you can't really make much progress changing things and building positive self esteem, finding positive healthy relationships, and being able to build a life that makes you feel content rather than miserable.
I suspect it might seem too much at this point to look at resources on abusers, but I think Women's Aid and the Freedom Programme would both be great sources of help to you. If you can, I would really encourage you to explore those options, even if you can only bring yourself to do so in small doses initially.
One of the ground rules of the Freedom Programme is that you don't have to have any intention of leaving to attend it or contact them for support, and they won't instruct you to leave. You can just go and gather the information they can give you about what abuse looks like, what a healthy relationship looks like, and why you've ended up in this situation. Abuse is more subtle and gradual than using abusive language or aggression, although those are features. FP can give you the facts you need to make sense of your life and see a way forward.
I write this as someone who turned up to the FP adamant that I want being a used, that I was in the wrong place and didn't need to be there, and then sat in horror as they described my abuser in great detail and went through the catalogue of things that happened in my home that I had thought were all my fault or just how it was for everyone.
They knew nothing about me, I had told them nothing other than my first name; they were simply describing what abuse really looks like. And it matched my life.
I also found the book "Why does he do that: Daily wisdom" helpful. It's about finding a way to take control of your life and your future, whether you stay or leave.
Your life doesn't have to be the way it is right now, it can absolutely get better and change beyond recognition. I hope you're able to find a way forward.