It can't hit the opponent directly like an actual Fireball can, but the Warrior tokens can attack multiple times, so it might even deal more damage over time than a traditional Fireball
Otherwise, the normal deck construction restrictions for the given format apply
If Jason Bright came up short a few too many times, I'd eventually adapt it to the meta and possibly add in that Nim Deathmantle combo
maybe in an activated ability deck that can flicker a lot, but otherwise, not so high on it
You can leverage this as a two-for-one quite easily, either as a surprise combat trick that eats a creature or a counter-bounce spell that mimics Cryptic Command
If a Manic Vandal is essentially a Gray Ogre that smashes the opponent's Bubbling Cauldron when it hits the battlefield