I meant stupid as in "utterly unnecessary and creating a lot of problems while not adding anything of value to the story".
I see. As expected, I partially disagree. I will say, however, that the Prophets/Emissary material from approximately
The Reckoning onward, is not handled with the same elegance that characterizes episodes such as
Destiny,
Rapture,
Sacrifice of Angels and
Far Beyond the Stars, so I understand why these creative choices do not always inspire enthusiasm. I have mixed feelings about them myself.
I don't think anyone was wondering why Sisko was the Emissary and asking for the "mystery" of his status to be revealed.
I don't think this is relevant: there's no reason to conform to the audience's expectations. On the contrary, one function of this retcon is to bring the paradoxical nature of the Prophets as non-linear beings into sharper focus. Over the course of seven seasons, we become quite confortable with the idea of the wormhole aliens, but perhaps excessively so, to the point where they start to seem like "masters of the wormhole" essentially, rather than the enigmatic figures of the early stories such as
Emissary.
So now we find out that the Prophets, after they met Sisko, actually decided to arrange his birth in the past. Which, of course, means that they had always arranged his birth. O-kay. This is becoming a "chicken or egg" problem. The idea of non-linear beings can create such logical problems, but I'm not sure why the writers of DS9 decided to highlight them with this storyline.
Precisely because the non-linear nature of the prophets' existence is what makes them an interesting sci-fi concept. As you suggest, the "chicken and the egg" problem is inherent to the idea of the Prophets from the beginning, and it's what gives them their power: they perceive all of time and can interact with any moment in time, thus "arranging history" as we might arrange furniture in a room. This same type of paradox is what allows them to insert prophecies into the past and shape the Bajoran civilization, as well as the path of the Emissary.
The Prophets employ a light touch for the most part: guiding and suggesting, rather than manipulating and controling. The Pagh-wraiths never get the development they would need to be convincing, but we can infer that their goal is to take control of the Celestial temple and manipulate time in a more tyrannical manner.
And really, WHY did the Prophets need to do that?
Simply because if they hadn't, he wouldn't have been born. This development is certainly not necessary in the strong sense, but it does bring into tighter focus the enigmatic and paradoxical nature of the Prophets' relationship with linear time.
And in the end, Sisko could just have been a normal human and nothing in the story would be different. So, what's the point of this whole reveal?
Bringing the enigma of the prophets into tighter focus is one reason, but there are others. This reveal establishes a more intimate relationship between Sisko and the Prophets, as expressed in his conversations with his mother Sarah in his visions (rather than with a random assortment of other characters, as had previously been the case).
Even if they wanted to have Sisko join the Prophets in the end, it still could just as well have happened without the whole arranged birth thing. If the Prophets like someone, if they have chosen someone and decided to 'resurrect' him and have him live with them, they could have done it whether his birth had been arranged or not.
Maybe, but the retcon prepares the viewer for this eventuality to the point where no explanation at all is required in
WYLB. Since the intimate connection with the Prophets has already been established, there is no need to speak in terms of "resurrection" or "divine intervention" at this stage: Sisko just returns to his mother in the Celestial Temple.
Now, I don't doubt that this could have been accomplished in other ways, but I disagree that the retcon has no impact at all: it sets the stage for Sisko's final transfiguration. The stage could have been set in a different manner, but something needed to be done to foreshadow this development.
It's not like he was physically any different. And it's not like they have more of a claim over him and more of a right to do what they want with him because they arranged his birth. At least I don't think so.
The Prophets are intended to be enigmatic, so I prefer that no precise explanation is provided. However, I think we can infer that Sisko's "pagh," "spirit" or "soul" is half-Prophet, whereas his physical body is human.
Now we learn that Sisko's fate had always been decided for him, even before his birth. What is that supposed to add to the story? It only takes away something.
On this point I strongly disagree. Sisko's arranged birth does not eliminate his free will: the choices he has made throughout his life are his own. He didn't control the circumstances of his birth, but then nobody does: he controled the rest of his life, however. The nature of this "paradox" is explored in
Destiny: the prophecy is fulfilled precisely because Sisko exercises his judgement and does what he thinks is best, rather than attempting to conform his actions to the prophecy.
This type of apparent contradiction is common in theology: for example, christian theology affirms both the omniscience of God and the freewill of human beings. Sisko's choices are his own; the Prophets, however, can perceive all of his actions and choices unfolding simultaneously from outside of linear time.
I don't mean creepy as "mysterious". I mean creepy as "disturbing and disgusting". Unless I missed something, Sarah did not want to marry Joseph, to conceive and give birth to Ben. Or else there would never have been any need for the Prophets to arrange the birth, would it?
This point I am more inclined to agree with: we are told that Sarah didn't choose Joseph, but that the Prophets did. And, to the extent that we are to believe that they enslaved Sarah against her will, that element of the story is a mistake. However, is it necessary to interpret these events in such a somber manner?
The only other time we have seen the Prophets inhabit a sentient being that I can recall is in
The Reckoning, and this is consensual: Kira is a willing vessel for the Prophet that possessed her. I think it's possible that Sarah was also willing to allow a Prophet to inhabit her body and to guide her, presumably because they made her feel the necessity of their actions. Sarah still would not have chosen Joseph (the Prophets did), but that doesn't mean she was possessed against her will.
Once the Prophet departed, she could not continue the relationship as her own heart wasn't in it.
Certainly this experience caused Joseph a great deal of pain, but it also brought him joy (he loved her) and a beloved son (Ben). There is also plenty of resonance between this... errr... unorthodox union and interactions between human beings and divine powers in actual religions. For example, I can only imagine what the biblical Joseph felt when he learned that the holy spirit had impregnated his bride-to-be and that he would never be able to have sex with her. Creepy? Sure, depending on your point of view, but one of the goals of this retcon was to deepen the resonance between the Emissary storyline and existing theology.
I can understand, however, not really wanting these ties to be strengthened in the first place. It is a somewhat heavy-handed approach (as opposed to the more subtle approach of
Destiny and
Rapture, which I admit I prefer).
If the idea behind this had been to portray the Prophets as manipulative assholes who treat humans as bodies to be used to their ends, then it was a good idea. But since season 7 attempted to portray the Prophets as good and their antagonists as evil, it really was a very bad idea.
We can infer that the Pagh Wraiths intend to use their non-linear status to dominate Bajor and the Alpha Quadrant, which they can reasonably accomplish by manipulating history from within the Celestial Temple. If Sisko's birth is necessary to prevent this from occuring, is the sorrow of one man and one woman too great a price to pay?
This echoes back to the moral dilemma of
In the Pale Moonlight: is the life of one criminal, one Romulan senator and the self-respect of one Starfleet captain too high a price to pay for the safety of the entire alpha quadrant? I think I could live with it. Was it necessary for Joseph and Sarah to suffer in order for the Emissary to be born and the Pagh Wraith defeated? Perhaps, and I think I could live with it, in their place.
I will say this, however: the nature of this moral problem should have been dealt with more explicitly. I would have liked to have seen Sisko question the prophets' motives more openly, particularly as they related to his father and human mother.