My $0.02
As per my experience over my last 36 years on this earth, and my brother's seven years as a police officer in a mid-size city (pop 300K+):
His quote: "99% of the sworn officers support the RKBA, incl. EBRs and CCW."
We talked about this whole "LEO vs. RKBA" issue over a beer during one of his infrequent visits back east.
Basically, the anti-RKBA image comes mainly from media coverage of police chiefs from places like NYC, Miami, SF, LA, Chicago, etc., who parrot the far-left city councils that appointed them to their positions. Or other police appointees who parrot whomever appointed them. One example is the Maryland State Police legislative liaison who had to come testify in support of an EBR ban the first year after our new anti-RKBA governor got elected. For the four years prior, the same MSP officer came to testify AGAINST the exact same bill. He got his marching orders from the new MSP commander, who got his from the governor.
You take media saturation of police chiefs like Timoney railing against "semi-automatic killing machines," coupled with the fact that many officers from places like NYC end up moving to places like Virginia and bringing their culturally ingrained anti-RKBA biases with them (causing spectacular screw-ups when these transplants first encounter lawfully armed citizens), and PRESTO you get the impression that a good number of LEO's are really named J.B.T. Kittenstomp.