There are certainly exceptions, I've met a few, but in my experience small-town cops aren't typically bullish on private gun ownership either (except for themselves of course..)
The phrase "I don't approve of what you're doing but I'll defend your right to do it" comes to mind.
Things like the push for 2A Sanctuary Cities may be pandering, but I think it wouldn't be happening if the cops in question were strongly against civilian ownership of firearms.