I’m temporarily in the USA but normally live in another country; can I apply for an Irish passport here?

No, you must apply in the country you are normally resident in.

You should only contact the Consulate General of Ireland in Atlanta in the case of a lost or stolen passport while visiting the US south-east.