*Disclaimer: I disagree with our use of drones, don't think anyone should come to take away private guns, and don't believe any of this is a real risk. I'm just trying to understand the large group that believes their guns will protect them from the military.
A few lone nuts would have no chance against the government. But if the sentiments and fear spread to the point that entire towns were like-minded in their opposition, you'd have a guerrilla warfare situation like we saw with insurgents in Iraq. In that situation, the government's job becomes much more difficult, and assuming carpet bombing is off the table, small arms indeed can make an impact.
If just a gun is enough to reduce your fear, you haven't been thinking about it hard enough. (Or maybe not playing enough Fallout.) Battles can be lost with poor logistics before strategy or tactics even come into play.
If you ever see a day where you need that gun against a rampaging government, you're not going to be able to make full use of paper dollars, public networks, broadcast media, retail stores, power grid, refueling stations, police, hospitals...
I think people actually keep guns because they fear both too much government against them and not enough of it for them.
I don't know if that made any sense.