America has a lot of problems. I would say school shootings are not terribly high on the list. Same with mass shootings. Gun violence is a very touchy subject in America, as outright bans violate the 2A of the constitution which many believe was inspired to protect against formation of tyranny. Personally, I see the value in citizens being able to own rifles; not so much with handguns (which seem to only be used for murder and suicide).
But imagine if Hong Kong had 2A rights. Protests would be much more violent, yes, but the violence would be up-front instead of postponed until the next revolution (an ounce of prevention is worth a pound of cure...). Beijing would be forced to either back off or straight up invade. Instead, I predict HK's rights will be slowly eroded in a war of attrition until they are all trapped under the tyranny of the CCP for generations to come (which is arguably worse than up-front violence).
You have no idea what would happen if Hong Kong had "2A rights".
Right, because they don't. Just like every other country that slips into tyranny. The absence of 2A rights in countries ruled by tyrannical regimes is deafening.
Anyway, in principle any death for any reason is unacceptable. In reality, however, we need to decide how to allocate limited resources to making various classes of death less likely. Given that dying in a mass school shooting is much less likely than dying from a lightning strike, and is about as difficult to prevent[0], it doesn’t make any sense to focus on.
[0]: No, we can’t just “make guns illegal”. The political structure of the US makes this impossible.