I thought this was an interesting perspective. I found only a single study into this issue in the journal of public health. They found the opposite.
Ex-military cops were almost 3x more likely to be involved in a shooting.
https://pubmed.ncbi.nlm.nih.gov/30281075/