He can be godless and reject Christ in favor of the dark side and still write a song.
He actively chose to put sexual and occult if imagery in his BlackStar video near the end of his life. So that shows what he believed in.
I'd say Bowie produced a scathing critique of them.
But I'm sure you've got an angel telling you to judge.