Well, just off the top of my head, "Study War no More" and "Last Night I Dreamed the Strangest Dream" are both inspirational but perfectly suitable to atheism. Most ballads of adventure are, as well. Atheism not being a creed per se, it makes sense there would be no songs asserting it.

A