I don’t know what to do..

My husband and I have been married for 7 years together 10. I love him so much. He’s an amazing dad, he works hard, makes me laugh, we’ve been through hell and back together....however.

Lately it seems as though he just not attracted to me. Or only wants to have sex when he’s randomly hard (which is maybe once in a while). I’ve tried being extra with him. But he just falls asleep. He works really hard so I’m trying to be understanding but then this morning he went down on me and when I pulled him up to me... he went soft all of a sudden... I’ve never felt so unattractive. I don’t have many people to talk to so...am I doing something wrong? Is it me? Did we just “fizzle” out? Please no rude comments.