People list cases when guns did not help, but there were cases when it did. for example, there was an attack on a place of worship in Texas, where worshippers responded with precise fire preventing a mass murder. So, even as most Jews do not carry, maybe we should ….
In shul, you need some safety measures, of course. No guns during kriya, for example, so that bad reading and corrections do not trigger anyone.