The U.S government were willing to ratify the Eighteenth Amendment banning alcohol because of its harmful effect [...] why can't the same God fearing people get all riled up about this?
They do get riled up about it. Not in the way you mean though. Any time there is talk of gun control, the NRA tells its adherents that THE GOVERNMENT IS COMING FOR YOUR GUNS! And the jungle telegraph lights up with defiant hillbillies screaming about prying their guns from their "cold, dead hands."
Ignorant irrationality aside, no modern country is going to amend their societal rules to allow the state to walk in to the citizens homes and take whatever they find offensive. We already have that in some places and it doesn't really make for a peaceful society, does it. Given the choice between a random lunatic possibly shooting you or your own government possibly shooting you, most people will opt for the random lunatic. Though if you ask a lot of black Americans they'll say they are already equally at danger from both sides of that scenario.
This is our culture, and if people really didn't like it they'd do something about it. But we don't, so draw your own conclusions. Gun owners here are not going to get behind a push to eliminate guns so that the country will eventually, maybe not have any gun violence hundreds of years from now. We're not that forward thinking as a whole, and the gun owners among us - at least the NRA, freedom, Confederate-flag-on-the-truck, cold-dead-hands types - even less so.
Having said all that, I grew up around guns and I have guns, so I'm not impartial. If "they" came for the guns, mine would just be well hidden. I'm not going to give up my
edge, you see. Which I'm sure is a common feeling.