In the 2006 TV movie, "Fairy Idol", he is the main antagonist. Norm's most sinister plan was when he used a cruel Timmy clone to make Cosmo and Wanda quit. He then attempted to become a fairy godparent by any means and succeeded. But he soon found it was unbearable. Once he was changed back into a genie, Chester wished for him to change everything back to normal which Norm painstakingly did.
Norm is a Genie that can grant wishes free of Da Rules. Timmy quickly discovers that wishes granted by Norm are usually taken too literally or intentionally misunderstood by Norm, in essence he is a trickster. He enjoys seeing others fail miserably, causing them harm, predicting their wishes for fame and fortune to come crashing down (which they always do). Norm seems to show some sympathy by at least warning his victims of his nature, usually through sarcasm, but the people he encounters are usually too dumb to notice until it is too late for them.
He talks to other characters with a sarcastic, mocking tone. Norm hates Timmy and has the utmost contempt for fairies. He was willing to ally himself with Crocker, presumably under the pretense of getting rid of Timmy, but Norm found it more entertaining to torment Crocker instead. He seems to enjoy making others miserable as opposed to fairies, who help those they grant wishes to.
Prior to being discovered by Timmy Turner, Norm resided in a lava lamp which was actually his genie lamp. Although he can grant rule free wishes, these wishes are granted precisely without giving the wisher exactly what he wanted and, in fact, often putting them in danger. Norm hates Canada, and when asked why he simply answers "They've had it too good for too long." He has allied himself once with Denzel Crocker in order to get rid of Timmy forever, but this time, he was more interested to see Mr. Crocker fail every time. He then convinces Timmy through a temporary truce to trick Crocker into going onto Mars by luring him with pizza. Because of Crocker's Wile E. Coyote's backfiring attempts on Timmy, Norm nearly had a nervous breakdown and temporarily teamed up with Timmy to send Crocker to Mars (which he kept suggesting for Crocker to do to Timmy only for Crocker to shoot down that idea). He longs to be a fairy godparent and sabotages a "Fairy Idol" contest to become one. He wins (after putting Cosmo and Wanda out of commission temporarily) and later explodes because of magical back-up. Norm also somehow knows the fairy lawyer Fairy Mason.
He plays a big part in the special of "Fairy Idol" as the main antagonist. After reading about what happens when a fairy quits their job through Da Rules (he had this book because Cosmo, at an earlier point, gave it to him as there were no pictures in it), he decides to use this to get out of his lamp. After seeing a photo of Timmy and his godparents, he decides to make Cosmo and Wanda as part of his plan.
He makes a clone of Timmy Turner, who acts abnormally weird to Cosmo and Wanda and abused them, causing them to quit their jobs as fairy godparents which began auditions to be the new fairy godparent and he participates to free himself from his lamp. His plan was thwarted at the Fairy Idol competition, when Cosmo and Wanda realized they have been tricked. He then incapacitates them temporarily and bribes Jorgen with a piece of rope while using a wrecking ball to injure Cosmo and Wanda becoming the new fairy godparent and was assigned to Timmy's friend Chester granting him his freedom. He was annoyed because Chester constantly called him to make wishes to "help" the world. After seeing Timmy sad, Chester made Norm Timmy's new fairy godparent. Timmy got revenge on Norm by not wishing for anything for two weeks, causing Norm to explode into confetti string (magical back-up), which is what happens to Fairy Godparents when they didn't make a wish for a long time. After he was returned to normal, he quit, causing Jorgen to appear to remove Timmy's memory and make Norm into a genie again. Despite the loss of his freedom, Norm doesn't care and believes he still won in the end having gotten his revenge by cheating Timmy out of his fairy godparents and Cosmo and Wanda out of a job, but Chester then sucked Norm back into the lamp with his last genie wish and got everything back to normal. Norm has not been seen since then and his lamp is presumably still with Jorgen as of now.
Role in the series
Norm is not a good choice for any of the villain teams in the UUniverses, and is considered a disgrace to fellow genies such as Genie and Jafar. Thus, even they would never consider freeing him from his lava lamp prison.