Social workers can offer fab support. We've had a few. Very dramatic family events and disabled DS. They're people in the real thick of the community and can help with some really basic stuff that actually makes a difference in life.
We got bumped across to family support, then due to not meeting criteria dropped off that. My family worker was lovely too. She could get answers to my stupid questions like if DS1 went to school X how would that effect DS2 and DD's schooling options.
I did a spell working supporting families with homestart. One of the things talked about was how we often got involved when things were really already in a bad place. If we could have introduced ourselves in pregnancy and just said 'hey were here', to families where maybe there are historical mental health issues or DV issues we may be able to offer support just that bit sooner and not be breaking down barriers with exhausted isolated mums.
You sound really together and excited about having a baby. Thats great. It's also fine for everyday not to be a bed of roses.
Whilst I think bizarre situations do occur at every extreme in general social workers work long hours with large case loads because they really care about people and bend over backwards to help people make the very best of their lot.
I too was rather intimidated by first social worker HOUSE INSPECTION home visit, my house was clean, DC not allowed to breathe incase anything smudged. I soon realised they weren't actually judging finer details of my home hygiene, just a quick check that we all had beds, bedding no pet shit on the floor etc!