SNW S2E02 introduce a new quirk of the canon: The time “push back”, such that there will be some events (let’s just call it Canon Event) that will always come about in Prime Timeline, albeit in different actual time. Aside from the aforementioned Eugenic War, I can think of a few other so-called “inconsistency”, such as how there are already Cloaking technology for both Romulans and Klingons before Kirk’s mission, despite TOS dialogue implies that Romulan first got cloak during Kirk’s mission, and then transfer technology to Klingon. (I think the current explaination is different cloaking technology, which have various quirks.)
So here’s the question: Under what situation would you consider “Time Pushback” being an acceptable explaination for discrepancy??
There are certainly cases like that.
The Guardian of Forever has also corrected the timeline in two cases we know.
But there have been causality loops such as in First Contact where time arguably pushed back on its own, with the Enterprise working to correct the incursion of the Borg.
I think that you could make a good case for the First Contact/Regeneration/QWho loop directly being Q’s creation, rather than a vague sense of fate.