I've never lived in an ex council house although DH did for a while as a teenager I think, but from what I can gather I'd agree with other posters that older ex council properties are often well-built, solid and roomier.
As for main roads - I have lived on two of these and wouldn't recommend it at all!
Our second family home was a very handsome square Victorian house with door in the centre - many people's ideal - on a main road, sited near to a junction with traffic lights, double yellows and a bus stop (I know, what were we thinking?). The noise - we had no double glazing but did have a front garden, albeit a shallow one of about 1.5m - was horrendous 24/7. We had to rent a garage nearby as parking was appalling. Weirdly 17 years after we sold they still haven't fitted DG!
Our last house was on an A-road in a rural location. An extremely pretty three-storey thatched vil?age house built with no foundations in the Georgian era. It fronted directly onto the relatively wide pavement with no front garden or forecourt. Unfortunately with the exception of two extensions - including one added by us - the property was one room deep, so that seven rooms fronted onto the road. Every time a bus or lorry went past too f*cking fast the house shook due to its lack of foundations!
We fitted (hardwood, painted sash) accoustic DG to combat the noise, but it was still audible when you were in the front rooms. Luckily the garden was huge so road noise wasn't an issue out there. Tbh, whilst we no longer have young DC, we do have cats and ours never went near the road and I don't think having young DC in itself would put me off......I just hate road noise with a vengeance and feeling as though you're living in an earthquake zone is not my ideal......