Can you imagine paying everyone in San Francisco enough salary so they can afford a 2nd bedroom? Don't be silly.
And yes, working from home without a home office with a door is not the same as having a private office. People have roommates and kids and spouses and all sorts of things that are even worse than coworkers when it comes to focus.
Social is a big spectrum. Keep to your end of it and there won't be any problem.
Also, often the problem I'm working on requires focus. For example, how much talking has occurred during ANY math test you have ever taken?
This test was oral by the way, but took about an hour (or more?), professor and protocol person. Sure there was writing but also a lot of talking.
I think constraining our industry on solitude is also a reason for the low diversity.
I think the more open the place, the better. We are social animals. If people choose solitude, it's likely for wrong reasons. (Not saying that there aren't ever reasons for that, (almost) everybody needs some privacy every now and then.)
But yeah, all people must also think of others, people who don't do that are likely making work a bad experience.