In part the "bad" name helped to spread the word of the product initially; it was a hook for many stories that would otherwise not have been written IMO. Thousands of media outlets poked fun at it all the while informing the world about a revolutionary new Nintendo system.
Oh, how the jokes flowed when the name was announced. Then the sales numbers came out, and people stopped joking.