Real talk about men and children

So I’m sitting here pretty heartbroken and don’t know if I’m over reacting or not able to face reality. Back story: my husband and I have been together for 6 years and TTC for 2 years. I have two nieces (12 and 6) that I love like my own (basically raised the oldest one since she was born to my sister when she was 16) and they fill my heart with so much joy. My husband understandably doesn’t like my sister (she does have serious issues) but has had almost zero interest in my nieces. He will go to functions for them like soccer games or school events without complaints but pitches a fit if I want them to come over or take them to fun places with us. Last night, he asked me if I wanted to go with his friends (and their two babies under 2) to a fall festival today and kind of blew up at me when I asked if I could take my girls too. He said he doesn’t want them to go and doesn’t want to be around them or responsible for them. He had so much hate in his voice towards these girls that have been in his life for the past 6 years that it not only broke my heart but made me sick to my stomach. And now I’m questioning if he’s even the right person to have children with. Like why would I want to create humans with someone who has such little compassion? I’m confused, hurt, and not sure what do from here. Haven’t talked to him since his explosion last night. And he’s made no attempt to talk to me either.