As cool names for science fictional propulsion systems go, "spore drive" ranks pretty low, somewhere below Farscape's Hench Drive. I also can't really get on board with the whole concept of there being a galaxy-spanning network of fungus that serves as a means of instant transportation.
Since we don't end up with a setting where warp drive and transporters have been replaced with mushrooms, I'm guessing Lorca's crew are going to wind up breaking the mycellium network in some fashion by the end of the series.
Aside from the problems mentioned above, "instantaneous" transport doesn't appeal to me because we've seen it before. TNG encountered an ancient "lost" tech that could transport farther an faster than transporters, and Voyager found another one in the delta quadrant. And that's just the ones I remembered while watching the Discovery episode. I'm sure there are more. It never sticks; it can't stick; it's boring.