That is definitely not normal.
Unless you're aiming at kids. The game won't let you kill kids but you most definitely should be able to aim and shoot random pedestrians.
Yeah, I was on the highest point in the city that you can get to normally and was able to sniper pedestrians all around me. Not sure if the DISTANCE was a loop hole or not but I could shoot them. None of the police could get to me because the platform I was on could only hold one person!
But fighting crime is my thing it did not feel good to shot the innocent sprites. So after 5 minutes I just reloaded my game session and went on a Parkour run instead.
Speaking of which...
The only NPC that I have found other than kids that the gun would drop away from was the Red Menace. I found her just standing on a roof top in China Town while I was doing some Parkour. I read later that she was part of a quest. I think the DEV forgot to make her de-spawn or it was a bug.
I have been even looking for a mod for this but cannot find one. I started the process of getting the mod tools to make one myself however, well I am avoiding all mods until after the DLC. It worries me there is no mod for this yet and so few mechanic changing mods. By this time with Skyrim and Oblivion there were hundreds of game mechanic changing mods. Makes me a little worried that maybe you cannot make such powerful game mechanic mods in this game.
Nexus Mods has changed SO MUCH over 10 years in the way you can find mods that maybe I am just not finding what I want because I do not know how to use their search tools as well as I use to.
PLEASE CDPR please make crime respawn in the DLC like in the first release of this game...