so frustrated with my husband!! 😡

I love my husband dearly but he is such an ignorant twit sometimes. He is in the army so goes away a lot and if I'm honest I'm sick of it. I'm finding it very difficult with him being away and being alone this time round as I'm pregnant and hormonal. I live 500 miles away from all my friends and family and have no friends where I live so I'm really really lonely. I tried to explain to him how I'm feeling and he just got mad at me and told me he is sick of listening to my shit because I keep asking him to ask his married friends over with their wives so I can make friends and he refuses saying it's not his job to help me find friends but I really don't have any other way! I'm not gonna stand on the street corner and ask random women to be my friends I need his help but he refuses! I need some advice ladies what am I supposed to do?! I'm going insane here!