Personally I would say that is kind of a big deal, especially considering how well guardians getting friendly with the hive has worked out in the past, but apparently it isn't.
Honestly making a pact with Savathuns worm has had a bigger impact on the story
-
We didn't really make a pact, Xol just gets more powerful every time we use Whisper, which the Guardian does solely out of their love for loot (which EVERYONE has commented on at some point). I think Xol could come back post-final shape as more powerful, and potentially leading the other worm gods.