It took half an hour, but I finally managed to figure out where to find an answer and found this (DDAL s9 content catalogue):
Sword of Zariel Only one good-aligned character among the group can attune to the Sword of Zariel, and only if you’ve deemed that they’ve acted in a manner that would cause it to choose them. The sword won’t allow itself to be attuned to any character that entered into an infernal pact, spent or used any charges from a soul coin, or willingly subjected themselves to Flesh Warping.
The attuned character undergoes the transformation as normal, but upon concluding the adventure, ascends to the heavens--becoming an NPC. This conversion is irrevocable--even by means that would normally return a character to play--and the character should be informed of as much before they make the decision to remain attuned to the weapon upon completing the adventure. If the wielder of the item unattunes to the item before ascension, the transformation ends, and the character no longer retains the benefits of attunement to the sword.
So, yeah. You have to lose the sword or lose the character (but you can use it until the end of the adventure)
In the hardcover my character pulled the sword of Zariel and was turned into a quasi-celestial. Do I get to keep that going forward?
It took half an hour, but I finally managed to figure out where to find an answer and found this (DDAL s9 content catalogue):
So, yeah. You have to lose the sword or lose the character (but you can use it until the end of the adventure)
I appreciate that. Thanks!!