it didn’t seem to have an answer for why the Federation didn’t use it later.
Well, you need to either find and enslave an exotic space tardigrade in order to navigate the network, or illegally splice said tardigrade’s DNA into your own.
And even then, navigation is pretty challenging, and can result in accidental time and/or interdimensional travel.
And a malfunction has the potential to destroy all life in the multiverse.
And both ships that had the prototypes installed were lost within about a year.
Spock flat-out said it at the end of “Such Sweet Sorrow, Part 2”, albeit with a focus on the time travel shenanigans of the second season:
Regulation 157, Section 3 requires Starfleet officers to abstain from participating in historical events. Any residual trace or knowledge of Discovery’s data, or the time suit, offers a foothold for those who might not see how critical, how deeply critical, that directive is.
Therefore, to insure the Federation never finds itself facing the same danger, all officers remaining with knowledge of these events must be ordered never to speak of Discovery, its spore drive, or her crew again, under penalty of treason.