I'm under the impression that having one's head up one's a** and being up oneself is different. The first means to be stupid and clueless and we can tell someone "Pull your head out of your a**!" to mean "Stop being so incredibly stupid!" The second only means full of oneself and there's no equivalent "pull yourself out..." command.