Not for me. I am fully aware of how special effects are done and actually select where I go to see movies based on what kind of effects I'm expecting. A movie, no matter what movie, is an escape from our everyday life. We go to be whisked away into another place and time. What better way to immerse ourselves in the magic than with special effects?
Knowing the end of a book doesn't keep me from reading it either.