He could be the sort of Trickster who is like 'well, personally, I don't believe in the existence of any gods, but I'm certainly not going to complain if other people wish to worship me as one'.

Ooh, I rather like this idea.

Atheistic angels are already canon on Supernatural! Uriel outright said 'there is no God' in 'On the Head of a Pin'.