All cities need contrasting spaces. Even the medieval town or city was marked by narrow streets that led to an open piazza or square. The feeling of walking from a confined narrow space into a wide open expanse can give a feeling of exhiliration. It's something architects continue to use today inside buildings. Think of the walk through a corridor into the grounds of a stadium and the excitement it generates. Or the excitement of walking through a corridor in a theatre before you enter the large expanse of the auditorium.
The scale and proportion of buildngs in relation to one another creates a sense of enclosure that can either feel comfortable or uncomfortable. The author calls the extremely narrow streets "intimate" and they are in many cases, but they can also be claustrophobic (especially if you live in them).
For housing, not everyone will want to live in streets as narrow as the pictures in the blog post. Who doesn't prefer long views out of their window? (Preferably of some greenery) That doesn't mean building huge spaces between houses as is often the case in modern car suburbs. But there needs to be enough distance to psychologically feel you have a sense of privacy from your neighbours.
Here is a random Victorian street (in a very expensive part of London) that I think has a good scale. The road is not too wide. Cars are parked on the street rather than in garages. The houses are of fairly high density. This is a better template for housing than modern car susburbs in my view. But it won't be for everyone.
https://www.google.co.uk/maps/@51.556208,-0.165162,3a,75y,36...