Even when giving scientific talks, the advice I give my students and post-docs is to first have a clear idea of who the audience is: is it
a) experts only from your area? [e.g. conference]
b) people from the same department who may be generally aware of the area without knowing specifics? [e.g. job talk]
c) General public [e.g. showing lab to school kids. This is the level at which you talk to the public. soundbites - so it is invariably misrepresented by the media]
All three levels require different approaches for the same subject. (b) is especially tricky - you are talking to experts, but from a different field. So you have to simplify, while not being patronizing. As for (c), I think it is best to avoid it. Except in situations like the pandemic, it rarely is beneficial. Also, to do it right, it requires a lot of preparation.
I'd be curious if you disagree with any of that in theory or just have a better appreciation of the practical difficulties...
Discussions on social media rarely indicate much effort at nuance...
This seems like a false dilemma. Joe Public is as capable of reading a paper on sci-hub as anyone else. It would probably do everyone a bit of good if JP were more likely to do that when he's wondering what to do about the aphids in his garden, or read a patent relevant to his mechanics business, or assess the evidence around masks during a pandemic. And I think it's the idea that science needs to be dumbed down for a certain kind of person that keeps ordinary people from digging into the asterisks when things are relevant to what they're doing. Executive summaries are useful when something isn't very relevant, which is most of science for most people. But some science is relevant to everyone, and it would be good if we challenged the myth that one needs to belong to some kind of separate class in order to practice science. Science is for everyone. No one can know all of it, but everyone will come to a point where they'd benefit from knowing some of it.