No plot hole is unfixable. As has been said in this thread already readers will forgive, or look past entirely, a plot hole if the book is enjoyable.
I had a massive oversight in the novel I completed earlier this year. It wasn't quite novel-ending, but it was glaring mistake. Took the time to fix it and the story came out better for it with the changes I had to make.