Stay or go?

Hello everyone :-) I have been married to my husband for a year next week. I am 38 and he is 39. He has a drink problem. He drinks 7 or 8 beers at least practically every night. He also has other issues. None of his family like him. His two sisters and brother dont talk to him. And when they do talk it just ends in an argument so it just cant be resolved. He is constantly sad about this. His parents have both passed away and he inherited the family house which has a great deal of equity in it. Yet also has a mortgage. Because he has bad credit he is constantly occurring problem after problem as he has previously taken secured loans on the house and has missed payments. I said i would help him. And give him 40k to clear an existing loan on condition he would put my name on the title deeds so i am covered in case if marital breakdown or any other problem to which he agreed. My problem is however that i would like to try for a baby because of my age. But he never wants sex. Is not interested. Yet i know he watches porn now n then. This upsets me as hes not interested in me in that way but can watch porn. When i try and talk to him he says its me. How he doesnt find me attractive. Or he will say that im not ready for kids. I need to focus on my career. I would be a bad mother as i am lazy and wouldnt get up for the feeds. This is untrue. As i know how i am. And his put downs are a reflection of himself and not me. My question is that if he is not willing to compromise with me with my needs. Should i bind myself further by putting money into a property. Or should i walk away and find someone who is on the same page as me. It doesnt help that i have a biological clock ticking away. Despite all the things I have mentioned we do get on well. But he wouldnt go to counselling and when talking about sensitive issues he goes into a rage. So i cant talk to him. I do feel for him as he is quite isolated and none of his family care. I have tried to talk to them asking them to talk to him. But they all refuse. No one wants to know him. What do I do?