It's no secret that the time travel mechanics as portrayed in Picard Season 2 were a little hard to fathom. My goal here isn't to answer every question, I'm not sure that's possible, but to propose a framework for the minimum amount of temporal manipulation you would need to explain the overlapping paradoxes, without resorting to the cheap "Q did it"-style answers (Q actually being responsible for most of this notwithstanding). If this looks familiar, it's because it's basically the same thing I posted on r/Picard last week, with some elaboration.
**tl;dr I think this season is best understood as an orphaned timeloop originally created and abandoned by the Borg that Q attempted to splice