If you are looking at the picture now, say
eg "Does this show a superstar or it is supposed to be somebody else?"
If you are speaking now about a picture you saw yesterday, say
eg "Did the picture show a superstar or was it supposed to be somebody else?"