the effect of any gun directly relies on the enemy it challenges.
when armors on knights became too strong swords would be laid aside and the firearm was picked up
when we come up with a armor that will resist the bullet then a new thing will spawn, be it a sound wave weapon or something that fires superheated plasma guided by electrical emmulsions (idea )

but if the gun does become futile to some new armor then a new weapon will arise