No, all profile pictures need to be approved. Its just a matter of when an admin gets to it. It shouldn't take too long.
I changed mine yesterday, taking off my own ugly mug and substituting it with one of my dogs. He duly appeared after a few hours but by late evening, had been replaced by me! Had he failed the approval second opinion test?