Spoilers: The fusion as Creative Assembly tells it; no campaign ending.

Who he is in Total War
Vilitch leads the Puppets of Misrule for the Warriors of Chaos. Champions of Chaos unlocks him beside Azazel, Festus, and Valkia. He is the pack's Tzeentch lord: a melee hybrid and a caster, not a flying Lord of Change and not a trickster who wears other people's faces.
The August 2022 introduction calls him a living piece of Tzeentch's taste for anarchy. The Great Sorcerer fused the frail runt to their warrior brother, so Vilitch has the baleful magic and the use of that sibling's strength. Enemies are meant to fear the Twisted Twin while the pair plot for more power. In battle, the passive of that name raises spell mastery, melee defence, and melee attack the longer Vilitch is either in combat or casting.
Changing of the Ways, from the first turn
The faction has Changing of the Ways, a teleport stance, benefits for armies with high Winds of Magic, and souls converted from its own battle casualties. Vassals gain barrier hit points and spread Tzeentch's corruption. The lord steals a share of the experience other lords earn. The store page adds the opening threat: he can teleport onto an enemy and attack.
Kairos Fateweaver is the base-game Oracle, two heads and a cult map. The Changeling, from Shadows of Change, schemes in borrowed legendary shapes and is not a conventional province war. Vilitch is the mortal twin who already owns a warrior's limbs. His puppets are a Warriors warband with Tzeentch's manipulations bolted on, including the teleport that lets an army arrive where the scheme points.
One fusion, two talents
The August 2022 introduction is the whole origin Creative Assembly printed for him. Tzeentch fused the frail runt to the warrior brother, and Vilitch kept the baleful magic together with that sibling's strength. One creature holds both talents. The faction that follows is named for puppets.
Update 9.0 includes him among the Warriors lords Archaon can subjugate. A defeat can move the Curseling into the Everchosen's roster and confederate the Puppets, because the faction is already Warriors of Chaos. That rule is shared with Azazel, Festus, Valkia, and the older undivided lords. It is a campaign recruitment, not a scene in which the twins change masters.
Vilitch the Curseling: gameplay and availability · More character stories
Sources
- Introducing Vilitch the Curseling — Total War — totalwar.com
- Champions of Chaos — Total War — totalwar.com
- Update 9.0 release notes — Total War — totalwar.com
- Immortal Empires DLC Ownership Guide — SEGA — support.sega.com
- Patch 9.0.5 notes — store.steampowered.com
- Update 9.0 release notes — community.creative-assembly.com
- Champions of Chaos — store.steampowered.com