Why have you moved out when he has no right whatsoever to make you homeless?
You've said he 'kicked you out' but, as you are married to this callous attention seeking twat, you have as much legal right to stay in the marital home as he does and I suggest you move back and tell the poor diddums that if he's dissatisfied with your marriage he can fuck off find alternative accomodation as it should be patently obvious to him that your need for a stable roof over your head is far greater than his.
Jeez, who does he think he is? Master of all he surveys? It's time to disabuse him of that particular notion and if he can't shape up, he can ship out of your life and leave you to raise his planned dc alone - and I have no doubt that once you're settled again you'll be a wonderful, and wonderfully happy, single parent
With regard to your housing application, it can't be said that all council/social housing is situated in rough/unsafe areas and it can be the case that what some may consider to be a 'rough' area has a more sociable/thriving community than other seemingly more desirable areas, but in any event the fact that you have a disability should have some bearing on the type of property and location you are allocated.
Many councils have resorted to renting private accomodation to house those who are in urgent need and I also suggest you make contact with Shelter www.shelter.org.uk/ who may be able to advocate on your behalf or suggest an organisation or charity local to you who can do so. If you don't intend to kick him out move back to the marital home, you're best advised to pull out all the stops to advance your application by getting your midwife/antenatal team, GP, local ward councillors etc on the case and copy all correspondence to your MP.
If you're on a council waiting list you can be nominated to a housing association and I suggest you have a scout around the areas you would like to live in to see if there are any new builds/renovations under way that have a billboard showing the name of a housing association and give them a call.
That said, imo you should seek legal advice from a solicitor who specialises in divorce and family law with a view to becoming the sole occupant of the marital home - Shelter may also be able to advise you in this respect.
I reckon something's been added to the water supply as there are a number of other OPs with current threads whose partners have also abandoned them late in pregnancy and you'll be in good company on this board.
Take heart, OP. It WILL get better and you'll always find support and encouragement here 24/7.