Memory Alpha and common lore seems to hold that "It just didn't work" or "The dilithium broke down"
That doesn't make a lick of sense. You would never get to the production stage where Excelsior was if the damn thing didn't even work.
My personal fanwank was that what they are calling transwarp drive is simply TNGs warp capability and not what the Borg had. Makes sense to me.