In ANH, we see Luke destroy the Death Star by using the Force while the only other pilot (who is presumably not Force-sensitive) to attempt firing his missiles misses. Is there any indication in canon that it was required to be Force-sensitive to make the shot, or could an average pilot with enough luck make the shot?
It could be made by a normal person.
In Rogue One we learn that Galen Erso is the man responsible for the flaw. He had to keep it subtle or the Empire would have found it. But he's banking on someone exploiting it to destroy the Death Star. Erso has no way of knowing Force users exist, so clearly this has to be a task a normal person could do.
The reason the first shot fails is it's still a hard target to hit (harder still with a Tie fighter piloted by a Sith Lord chasing you). The pilots note this in the briefing. Being a Force user just made it easier.