>But one could look at Star Trek and imagine it's plausible to live in a society that doesn't tolerate school shootings or the systemic breakdowns that led to that.

We already have that at least, it's basically anywhere but the United States.

Unfortunately if Columbine and Sandy Hook didn't change things for the better I think the US is a lost cause in that regard.