The correct answers are The tourists went to the church to take photos. and My grandmother goes to church every Sunday to pray.

We use the zero article (no article) when someone visits a place to participate in its normal institutional activities (like attending a religious service: goes to church).

We use "the" when referring to the building itself, such as when sightseers visit just to look around (went to the church).