The Demonology spell Demonbolt and the Destruction talent Conflagrate do have fire animations, but those are currently not affected by the Codex of Xerrath.

Burning Rush, Cataclysm, Felsteed and Dreadsteed are affected by Green Fire, but their animations have not changed from their live versions.

DISCLAIMER: Green Fire is still locked behind the questline that requires you to go to the Black Temple and defeat Kanrethad Ebonlocke. For the purposes of this post, the quest was actually completed during BFA Beta.