Or it will show up in the new movies (together with characters from STD), paving the way for a reboot of the whole franchise.
[Ten paragraphs of incoherent rambling accusing you of being wrong, a troll, drunk and for some reason racist who disrespects Canon and the sanctity of Gene's Vision.]
[Ten more paragraphs of even more incoherent rambling in which I accuse you of not being a real fan and project my problems with people in my real life nonsensically onto you. Seriously, chill the fuck out, it's only thirty-five dollars.]
[Ten more pages of incoherent ramblings of Sisko did this and Janeway did that and although they haven't been born yet it means spore drive IS possible but it will never be seen again?!?!!]
Maybe, but I don't think it's an accident that the writers used a mirror for their dramatic foreshadowing.
Once the Klingons or the Terran Empire get a hold of the spore drive technology, Starfleet decides they have to destroy the mycelial network to protect the Federation and the fabric of space-time itself.
Not having followed the ancillary commentary very much (so I don't know if it's been ruled out), I happen to like the notion that Discovery is from an alternate timeline/reality from TOS - and that's why it has so many divergent traits (holonet, uniforms, Klingons, Spore Drive, etc.) - and somehow ends up in (or passes through) the same timeline/reality of TOS. Or it's just stylistic decisions. In any case, it's one of the more interesting aspects of the show so far. The characters ... I appreciate taking a different approach, but none of them really appeal to me yet.
I'm sure the DSC writers will come up with a canon-y answer to this question (they've indicated they will make everything line up eventually), but I don't think it's necessary.
It may fit into a cannon, though. And then be shot straight outta that cannon from the canon. Seriously, no way this fits into the canon. They screwed up badly. (but "they're looking for solutions as we speak...")
No, I don't see why there would be any problem in using a Coca Cola drive either... it's just... I don't see anyone later using that magnificent Coca Cola drive.
The Coca Cola Drive has too many problems and it disrupts the fabric of the universe. Let's just use warp drive from now on. The end. Canon dicks touch.