> I don't know if au jour d'aujourd'hui sounds horribly redundant in French

No, we use it to emphasize that what we're talking about is as of today, but we can't make projections on the future.

You would use it in a sentence like : au jour d'aujourd'hui there are 'only' 300 deaths from the Chinese virus (implying that you don't know if it's going to get much worse or not).