Is "consarnit!" still current anywhere in the United States?

No, but “dadgummit” is. (Seriously, my dad says it.)