We are in the trenches right now (40, two primary age kids, work stresses etc) so there is the possibility that as the pressures on us ease we will be able to shake down together better.
I was struck by this OP, as I think young primary age is a stage where many people are feeling the pressures lift a bit, and describe it as an easier stage than others. It is less physically exhausting and relentless than babies and pre school years, but you haven't yet reached the emotional complexities of pre teen and teen years.
That's obviously a total generalisation and I'm not discounting work pressures, nor saying you're wrong to feel in the trenches. More that I think it's unlikely you'll feel parenting pressures lift for quite a while - if anything they may get harder or at least more complicated.
I have kids your age and a young teen - they all have different parenting challenges, but it's the teen who causes most difficult conversations with my (slightly grumpy) DH. It's relatively easy to agree a joint approach on discipline and boundaries for younger kids but we have slightly different mindsets on how to support the teen emotionally or at school, and it also brings up my own feelings about being a teenager and also unresolved things I'm still working through, so it all can become quite delicate.
Having said all that I do(again) appreciate work stress can be a major factor, things are much harder with me and DH when either or both are stressed.
I was also struck by your description of him being driven and ambitious and always looking for perfection. I would be thinking about how this might impact your kids as they get older, what expectations will he have of them? How will the sense that things are never good enough impact them? How might you discuss that with him now before they hit big pressure moments in their lives?
I don't have advice for your wider situation, just sympathy and respect as it sounds really tough and you clearly are doing a lot of work to reflect and keep things as stable and positive as possible.
On the specific question of whether to tell him, in theory I think it might be helpful to let him know if his attitude is impacting them, but in reality I have no advice no how to approach it constructively.