My friend and I wrote a comprehensive fantasy plot, but we've realised that our main character - who the story primarily follows - actually holds no major part in the climax of the plot, other than being around as it plays out. He's from another world and brought into this one as a prospective saviour, but his involvement in the conspiracy that leads to the climax of the story is minimal. Is this normal for a novel? There are other main characters who are very much involved, but is it normal for the main protagonist to act as merely a bystander in the main plot?
Yup! This is right. Although I must add that it can throw readers for a loop if the MC/POV character isn't as interesting as the others. There should be a good reason we are in his head rather than the protagonist's. What is his quest/goal? What's at stake for him? Why is he involved (and stay so if he really just sets the ball rolling)? Does the observation change him in some way? I'm not saying you have to make your POV character the protagonist at all, but you want to make sure that there is enough at stake for the him unless he is only a narrator--in which case you want to create an strong voice and an interesting perspective on what is going on in the story. Ya know? Consider The Great Gatsby. Gatsby is the protagonist (very arguably), but our pov character/narrator is Nick Carraway. Nick as little to do with the action of the plot, but he's there enough to be involved and offer an interesting perspective on all the events.
An engaging story can be told from many perspectives, from the main participant(s) to those in the periphery. In this there are no 'right' or 'wrong' ways.
In a lot of older stories, the kind of MC you envision was often a chronicler, a person who was there by choice or accident to witness great events and made the effort to record them while the "heroes" were doing the work.
Yeah, I think it's perfectly fine, so long as it's done well. My novel is a bit like this. The "main" character seems little more than an observer of the heroes of the story, but gradually he plays a greater and greater role and he's eventually the one who saves the day. I like this though, because it detracts from the "Chosen One" plots that I really dislike. I don't want my readers to assume that the day will be saved and that a certain character will do the saving. I prefer it to be more of a team effort, if you like.