Remote lock...by a supervisor
ACAB, first of all. However, and please bear with me;
I remember very vividly the video of a cop in Brooklyn minding his own damn business in his cruiser, probably eating a doughnut, when some dude walked up to his open window and blew his brains out. So how much time does that guy's partner have to radio HQ and request the weapon be unlocked before he is also looking at a new breathing hole in his skull?
I do agree that not nearly every cop should have lethal weapons. The temptation to go for it when frightened is just too high, especially for the type of people that tend to become cops in the US. However, having them remotely locked and requiring explicit permission also entirely defeats their unfortunately very real excuse for being out there in the first place. Let them all have tasers and batons as that's far more than enough for the vast majority of interactions as you pointed out, but to have the one lethal option perpetually out of reach even when its available and in that one in ten thousand case where it is actually required? Not entirely sure I agree there.
And just to be sure, I haven't forgotten OWS, so NYPD can choke on an entire bag of dicks one at a time and I'll sit back and watch sipping on an Arizona.