Pistols aren't memes, my friend. Due to their size and means of handling, they have different uses than shoulder fired weapons, but police are deployed as a gang of thugs, and in such use they are intended to just throw a lot of lead, rather than aim.

There is a reason 5.56 Nato is the round of Western militaries, and that's because it's a wounding round. Wounding an enemy requires the enemy to spend personnel and treasure on rescue, healing, and retirement of ex-combatants too damaged to continue to fight. Just killing the enemy only removes one soldier, far less expensive.

Asymmetric warfare is not focused on such engagements, and tends to focus on aiming at specific targets, rather than overwhelming them with volleys. Different forces have different purposes, and use different weapons. Pistols have a place in arsenals.

Where I grew up hunting for a living, U. horribilis was a common threat, and as a result I would hardly consider hiking, hunting, or fishing without a nominal sidearm. .44 Mag was considered the go to round for the purpose of dropping charging Grizzlies in their tracks when they were attacking. The reasons for carrying a sidearm, particularly a wheel gun (revolver) were several, and included redundancy, ability to be operated one-handed, and ease of carry in terrain difficult to carry a shoulder fired weapon in.