Okay ... that was fair (sarcastic, maybe even a bit pa ... but fair
) ... I will try to be more constructive!
I agree with the many posters who are pointing out that to have a first baby and sell up/move and job hunt in a new area and entirely change lifestyles all within a very, very short period of time, is an incredibly huge undertaking.
I also agree with ThroughThickAndThin who says of your husband "He's possibly scared shitless of either, let alone both together."
I think you should slow down, LIVINGTHEDREAM. Please slow down. I don't think you should give up your dream by any means, but I do think that ... in the short term ... you must prioritise your relationship with your DH and especially the need for both you and your DH to have a full opportunity to bond with your new baby in that important first year of his/her life.
I think you should sit your DH down and tell him that you are willing to compromise by staying in your present home for one more year (well, seventeen months, including the rest of your pregnancy). Tell him that you are doing this because ... first and foremost ... you want to be a family of three, not two and a weekend dad, or (worse) not a single parent with residence and a dad with very occasional contact. Tell him that you are compromising in this way because you recognise that becoming a parent can be a scary thing, that neither of you know how you'll feel and that you will both need time to adjust and to learn to be parents.
BUT also tell him, that this is JUST a compromise. That you do still want to move and that, far from it being a pipe-dream, you also want the time (the 17 months) to be used by you both to set that dream firmly into reality ... including things like putting your house on the market a short while after the baby is born; gathering information on available properties in the areas of your choice; job hunting (for him) and freelance work hunting (for you); etc, etc, etc.
In fact, when you think about the sheer number of all the potential 'etc etc etceteras', I really think you will need all of that 17 months (the rest of your pregnancy, plus 1 year) to make your dreams become reality, anyway, and ... this way ... I think there is a much better chance of you living the dream together, as a family.