OP you have asked if anyone has been in this situation and if they have found a solution.
I have.
When DD was 6 months old and BF, DH said I would like to give you a lie-in but I can’t, can I?
I said yes you can, when the baby wakes up you go and get her and change her nappy. Bring her to me in bed. I feed her in bed. You take her downstairs after she is fed and I stay in bed.
The very next day he did exactly that. From that point on, we each got a lay in at the weekend. The parent getting up sorted the kids (we went on to have one more) and kept them away from the sleeping parent.
DH sleeps better than me, more deeply, snores. But he has kids. So he wakes up and gets up when he needs to. Your DH could too.
He’s choosing not to - THAT is the issue. Can you tell him how it makes you feel, how irrelevant he must consider your needs, how he must really rate himself above you? Tell him it’s about the fundamentals of your marriage, not just sleep.
When your DH has work, how does he wake up then? If he can mange that, anything else is just an excuse to sacrifice you and prioritise himself.