ShareAlike is intentionally copyleft, yes. But it isn't clear what would constitute the 'derivative work'. If you had a glimpse of the photo in the movie with a 'Ken Burns' effect, would releasing a CC 2 sec video of that effect applied to the image be okay? Probably. But who knows if anyone would succeed in suing you to either CC the whole film, or pay for another form of license.
Is an article containing an image, used in its original form derivative? Probably not, the Wikipedia citation creator explicitly gives you this option: if you don't modify the image, only use it, then it doesn't prompt you to fill out the derivative information. Obviously that's not in any way legally binding, but gives an indication of how things tend to be used.
For example, there's case law regarding the use of a photo in a movie: http://fairuse.stanford.edu/overview/fair-use/four-factors/#...
From my understanding, the argument is that the website or document is considered a medium for distributing the image, but is not an adaptation or derivative work of the image. If the image itself was modified, that modification would have to be BY-SA.
Disclaimer: I am not a lawyer, and I am not liable for anyone taking above as legal advice.
Same thing for a movie that has just a glimpse of this photo or a computer game that displays it once?