If I prototype my sprite with an old photo of someone, and that someone is dead, will the sprite have the personality of the person at the moment the photo was taken, or the personality of the person before they died ? I'm sorry if it's not clear

Depends on how you value that person. I’d imagine the game would take what the picture means to you- The person or the moment, that depend on what you yourself think of it.