Danny Phantom features the name that makes almost everyone cringe, Nasty Burger, a name of a diner (After some vandals changed the T to a N, so the name used to be Tasty Burger). No one knows why the sign was never fixed. The burgers however have a sordid history of exploding in very hot climates.
In The Simpsons episode Flaming Moes, when Moe's bar is actually popular. Bart makes a prank phone call for a "Hugh Jass" and to his surprise, there actually is a guy with the name of Hugh Jass.
Something very similar happened in the episode Donnie Fatso, where Moe Syszlak got a call requesting for a "Yuri Nater", and called out to the patrons asking for him, with predictable results. However, it wasn't a prank call, as the caller did actually intend to speak with a person by that name (The man in question was the caller's Russian business associate), and the person Moe was implied to have chewed out on for it was actually Fat Tony, the mafia leader.
The "Flaming Moe" was originally named the "Flaming Homer". That is, "flaming 'mo" vs. "flaming homo".
"Don't worry, there will be no one to make fun of your name anymore, Mr. Glasscock."
In another episode, Cletus reveals that he names his kids after what they think will happen to them when they grow up. Isn't that right, Stabbedinjail?
Joey Joe-Joe Jr. Shabadoo, which at first appears to be a name Homer makes up on the spot for his hypothetical "friend." However, Moe's derisive reaction to the name leads a man to run sobbing out of the bar and Barney to call "Hey, Joey Joe-Joe!" after him.
All of the fake names Bart uses for prank-calling Moe's (such as "Al Caholic," "Jacques Strappe," "I.P. Freely," "Seymour Butz," "Homer Sexual," "Mike Rotch," "Amanda Hugginkiss," "Ivana Tinkle," and "Ollie Tabooger") qualify.
Most VB examples would be Fail O'Suckyname, because they're just bad aliases. Phantom Limb's real name and what's possibly Dr. Girlfriend's real first name have been revealed. However, an albino having the last name of "White" is unfortunate.
Dr. Girlfriend eventually became Dr. Mrs. The Monarch. The Monarch once referred to her as Dr. My Wife.
Looney Tunes used to play with this, the initials I.M. before a name suggesting their profession.
In an episode of SpongeBob SquarePants where SpongeBob and Squidward were trying to name all the customers that come to the Krusty Krab, they come across a guy that they don't know, so they ask his name. He keeps saying "What Zit Tooya". Turns out it was his real name.
Smitty Werbenjagermanjenson, whose name doesn't even fit on his headstone.
Sandy Cheeks. Especially if you take "cheeks" to mean "butt cheeks." Made even worse since "Sandy" was the name of the second most infamous hurricane in recent memory.
Played with in an episode of Family Guy: Peter tries to drum up support for a new pro-smoking bill. He then encounters (real-life) House Majority Leader Dick Armey (R-TX) and laughs hysterically at his name, refuses to believe it is his real name and then mocks him asking if his wife is called "Vagina Coastguard".
Pretty much a lot of Hanna-Barbera's cartoon animal sidekicks, particularly those whose names are one syllable said twice. The most notable instance of this trope being used there would have to be Touché Turtle's sidekick; you'd have to be a really cruel parent to name your kid Dum-dum.
Gorillaz singer 2D is actually named Stuart Pot, and became known as Stu-Pot prior to the accidents which gave him his "2 Dents". It could be worse; his father had the family surname legally changed from "Tusspot" after a lifetime of teasing.
Parodied with teacher Ms. Choksondik ("chokes-on-dick"). While the kids insult her endlessly, they never notice her name, though they do sometimes modify it insultingly (calling her "Ms. Chokes-on-rocks" or "Ms. Makes-me-sick").
The verdict has yet to return on Squeezeplay, but by Primus, the images that name invokes...
As if deciphering the proper romanization of Deszaras wasn't frustrating enough, the name also causes TF fans in Hungary to giggle, as it's so close to the expressions "de szaros" (how shitty) and "Beszarás!" (Holy shit!).
There's also a human country called Carbombya.
It was a thinly veiled jab at Libya. Casey Kasem found it so offensive he quit voice acting for the show, and Bluestreak, Cliffjumper, and Teletraan 1, his three main voices on the show, were written out.
Also, Diamond Tiara's father, who insists that everyone call him Rich. That's because the first half of his name is "Filthy". Luckily he has all those bags of money to make him feel better about, well, being named Filthy.
It could be worse. His grandfather's first name was Stinking. And he wasn't bornRich, either.
And now that it's canon, one can only assume (and hope) that "Derpy" doesn't have the same connotations in Equestria that it does on Earth.
Pingu's sister's name is Pinga. The word is probably meaningless in it's original Swiss French and the show was produced years before Pinga as a sexual slang entered mainstream North American English.
In a Robot Chicken skit where Gargamel turns himself into a Smurf, when asked for his name he nervously ends up with Gargel Smurf, which attracts the attention of Vanity Smurf.
A running gag on Time Warp Trio is that any villian that isn't a real historical figure will have a name that ultimately sounds like an insulting pun (for example the ancient Egyptian baddie whose name sounded like "Hot Snot".
Ms. Sara Bellum in The Powerpuff Girls. Her name sounds like "Cerebellum", which means brain. Ironically, we never see her head, hence the joke.
Likewise, apparently the Mayor's real name is "Mayor" and the Professor's real name is "Professor".
When Lucky is adopted in the 2010 Pound Puppies series, his owner gives the name "Mr. Chewy McFluffster". (The owner in question also has a hamster named "Prince Fudgiepaws".)
In "Olaf In Love", we find that Olaf's last name is "Hugglesbjork".
In another episode, a male Maltese has the name "Princess":
Rebound: If you're a boy, then why are you called "Princess"?
Princess: You ever hear of an adorable Maltese named "Ralph"?
If he didn't have such an appropriate nickname, Kick Buttowski would probably count.
In one episode of Foster's Home for Imaginary Friends Bloo offers a man a chance to adopt Cheese, and when the man seems to have doubts about it, Bloo offers to include another imaginary friend named Crackers. In the next scene, Bloo is trying to console Crackers, who is crying:
Bloo: I'm sorry, Crackers, I guess he was hungry... He must have thought I meant real crackers...
Crackers: That's what they all say! (runs away crying)
Another example of this Trope in the same episode is that if Mac had imagined him, as he first believed, then they would have been, together, "Mac and Cheese". Fortunately, as it turns out, Mac did not; Cheese was actually his neighbor's friend. (He had just gotten lost.)
Likewise, Bloo and Cheese together would've been "Bloo Cheese".
Taking it once further, the name of the kid who did imagine Cheese is Louise.
Bloo: I mean, jeeze Louise!
Cheese and Louise: Yes?
Archer has the KGB director Nikolai Jakov, whose surname sounds practically identical to the word "jack-off".
G-rated lampshading in Young Justice, when Impulse blurts out Nightwing's and Robin's real names in front of Beast Boy. Nightwing just looks annoyed.
BB: "Your name's Tim?! And yours is... [uncertain cringe] Dick?"
In Despicable Me 2, the head of the Anti-Villain League is Silas Ramsbottom. The Minions find his last name hilarious, and even Gru gets in a jab or two: