I go to church every Sunday.

Literal

Every-Sunday [on-に] church [to-に] go.

毎日曜日 is 毎 + 日曜日 ('every Sunday'), not 毎日 + 曜日. The two に particles serve different functions: the first marks the temporal point ('on Sunday'), the second marks the destination ('to church').