You're comparing apples to oranges.
Desk lamps are not trying to be human, even though Pixar has a way of personifying animals and normally inanimate things. People already have a natural inclination to attribute human emotions and qualities to non-human things and animals. We get attached to objects and we believe that our pet fish have personalities, a complete fantasy. However, that has nothing to do with the uncanny valley phenomenon. Your counterpoint, Final Fantasy, worked very hard to give very human qualities to very human looking CGI. The effect was not complete and many people were turned off by it. That is the uncanny valley.
Makeup and bras alter a persons appearance in a manner that is pleasing; most of the time. Makeup can enhance one's color to be warmer, or create a more even skin tone. However, the wrong makeup, too much makeup, improperly applied makeup, can trigger repulsion. Many people find clowns frightening or repulsive. Also, to your point, mimes make some people uneasy. People differ wildly on how much makeup is attractive. A bra can enhance one's shape. The wrong bra, not so much.
I think the bottom line is our brains don't like to be tricked unless we see it coming; and, like almost any human attribute, some people are more sensitive than others. Most people can accept an animation that has human traits but doesn't look all that human (Simpsons, Flintstones, etc.). They are so far from looking human that it doesn't trigger our alarms. Most people can accept a human that acts like a robot, or even a zombie. We see these things for what they are. Humans with decoration, not things trying to look like humans. Most people can not accept something that looks and acts a lot like a human, but not quite. It gets past some of our filters, but sets off alarms in others. We get conflicted subconsciously. We don't like it...