Well, it didn't blow up the campaign, but it certainly disrupted it some.
The drawing of the cards (see OP for their results) went as follows:
Fin, the halfling gloomstalker ranger (who I knew would not be able to resist) went first, drawing two cards:
1. Well - learns a cantrip! (in this case either bard or sorcerer)
2. Temple - future divine intervention
Next went Lux the tabaxi circle of the stars druid, she chose to only pick one card
1. Temple
Third character to pick was Ryn, the human swashbuckler rogue/fighter. He chose to draw one card
1. Flames He knows he has drawn the enmity of a devil, and soon it will visit him in a dream.
Lastly, in the first round was Sol, the human vengeance paladin. He decided to draw 3 cards
1. Tower - this made him draw two more cards and choose between them, drawing Temple and Euryale, it was easy to choose Temple.
2. Donjon - He disappeared and lost his final pull, reappearing in the dungeons of evil cultists in the Moathouse (though he hasn't figured that out yet)
Next round:
Fin decides to draw one more:
1. Puzzle. He loses 4 points of Intelligence (now a whopping 6!) and may draw another card, which he does, drawing. .
1.5 Campfire
Lux decides to draw 1 more
1. Tower, so drawing two more she gets Star and Elemental, choosing Elemental
Ryn decides to draw 2 cards in the 2nd round.
1. Star (choosing to raise his Intelligence)
2. Well (learning a wizard cantrip)
In the final round, Finn begged off, but Lux chose to draw one more card:
1. Comet
Ryn also chose to not participate further.
So nothing was that disruptive except the split party - plan to run a solo session or two with the lone player - the rest of the group was able to get some clue as to where their companion went via the Head Sage using his crystal ball to scry on the paladin, but they are at least a week's travel away, not including time for prepping for such a trip and any other delays or obstacles that might come up.
We plan to have the paladin's player make up a temporary replacement character, while doing interludes involving what the paladin is doing in the meantime.