I wish I could relate honestly, but I don't ever feel useless because I'm not married thankfully. Not to mention when I do start to feel a bit useless, I pull up my pants, do copious amounts of house work and I feel much better.
You know, most people under estimate the value of coming home and seeing the house tidied and clean. Smelling good, and looking visually appealing, both genders appreciate it, maybe men don't notice it as much but they notice when it's not done. That means they feel at ease in a clean home and having eaten a good hot home cooked meal.
I also cook, I love attempting new things for the family and they seem to like it when I handle the dogs, food, and dishes. They can relax and enjoy their time off work. I think when we feel useless instead of getting down on ourselves maybe just make a more conscious effort. Like, asking our significant others "is there something I can do to help?" if they say they got it, then trust that their fine.
I doubt you're useless, just because you don't bring a boat load of money. A relationship isn't all about money, and while it may seem like a cliche you do give him love and affection, which I'm sure he values a tone.