No one has every believed that the eucharist literally turns to blood and flesh. Your taste buds would tell you otherwise.
I also would not quite agree that religion has retreated to "questions that have no answer". They have more perhaps retreated to "god of the gaps", i.e. the creation, consciousness etc. These are very large gaps in scientific understanding, but of course this does not mean we need supernatural explanations for them, and it would be reasonable to expect science to fill these gaps eventually. But then again there might be limits to what can explain.
I also would not quite agree that religion has retreated to "questions that have no answer". They have more perhaps retreated to "god of the gaps", i.e. the creation, consciousness etc. These are very large gaps in scientific understanding, but of course this does not mean we need supernatural explanations for them, and it would be reasonable to expect science to fill these gaps eventually. But then again there might be limits to what can explain.