Welcome

and congrats on the new baby coming
Here DH saw how DD1s bum cleared up after changing to cloth and that got him on board of the idea. After that I made sure there where different kinds so he could find what he liked and not what I thought he liked. He prefered fitteds with covers or pockets for DD2 and he has come so far that he talks about the benefits of cloth to others
That your DH has said he would try is a start

I am sure that g-diapers are great but they are IMO not Daddy friendly

the velcro goes in the back and there is a loose insert in - that would have been having my DH running from the changing scene
But again my best advice is to let him find the kind he likes himself