Police say churchgoers detained the gunman calling their intervention an act of “exceptional heroism and bravery”