This is the low honor notification sound from Red Dead Redemption 2. It plays whenever your character's morality takes a hit, giving you that ominous reminder that you've done something pretty terrible in the game.
Low honor RDR 2 Sound Effect
Shared by Krabby