Sometimes it's the opposite, and you definitely do want meat flap acoustics often, and silent digital communication less so.
For any given company, you need to understand this. You can't just assert that an open floor plan "is collaborative." It is one kind of collaborative. It may not be the right kind for you. And worst of all will be to assert that it definitely is the necessary kind merely as an excuse when your real motivation is to minimize financial investment into physical space.
The headphone solution is also insensitive to people with extreme aversions to distracting sounds, such as sufferers of misophonia. In a lot of cases, if you are embedded in an open plan, there is no such thing as "opting out." It's a fixed decision mandated upon you.
But clearly for the people with more introverted working styles it won't work.
So let people pick. Want to sit in the communal workspace? OK, do so. Want your own office? OK done.
From time to time you'll need to intermix. Sometimes a social butterfly needs to tune out the distractions. Provide a place for it. Sometimes a hermit crab needs to sit with the team for 1/2 day and pair program. As Picard says, make it so.
This is not rocket science. The important part is that company management has to recognize that getting this right is one of the most important financial investments they will make. Instead of seeing space as a cost sink ... something to be standardized, minimized, and papered over with free lunch and dumbass "team building" shit, they need to recognize that of all the places to spend money, spending it on compensation for rewarding hard working employees is number one, and spending it on creating a humanity-affirming physical work environment is number 2. In visibly healthy companies, everything else hinges massively on those two things. Companies that have been so distorted away from humanity that they grind out success (generally for senior level people only) despite humanity-disaffirming workplaces ought to be seen as the frightening panopticons they are.