If, at the end of, or sooner in DSC, they ditch the spore drive and pull in line with known Trek canon, as seems to be the intention, it will still be a reset button, no different to the paradigm shifts we saw regularly reset in Voyager or after the whole Genesis trilogy in the movies. Repercussions explored to an extent, ditched, and as we already know, never mentioned in the future. It just take longer, in screen time, to have done it.
It will have to be very very neatly wrapped up, because any time a later crew is surprised to find organisms in other dimensions, or could have done with a spore drive or some remnants of the tech, considered a human component in a ship particularly unheard of, or considers instant intergalactic travel completely unimaginable, it would contradict this. (Which is probably why the tech is so top secret and only on one ship now...I wonder if the anti cloak algorithm will ever make it out too. If the spore drive becomes widely known in Starfleet, then lots of things we have already seen unravel...tons of Voyager, the Picard Manoeuvre, Iconian Gateways, even The Bajoran Wormhole to an extent. DSC has to end up almost a buried chapter. IF they do what they have implied.)
Or they don’t go Prime, and we have a ‘My name is Khan’ cucumber sandwich scenario, which is, I believe, still something of a sore point in some quarters.