"Energy vampire" metaphorically refers to someone who is routinely tedious or childish, sometimes on purpose, and are otherwise a drain on a person's time and resources. A woman is also sometimes called a succubus when in a relationship if it is for the same reason.
The joke is that saying "literal energy vampire" or "energy vampire is actually a vampire" is a pun.