Is Spigot more lightweight (in terms of memory and cpu) than a vanilla Minecraft server?
From the About page it seems like it has lower idle CPU levels, optimises some of the memory uses, and heavily reduces network usage. It sounds like it uses its CPU cycles better, but doesn't necessarily reduce them when it's not idle, in order to give higher performance at the same CPU usage.
Apart from guesses from the About page though, you can only really try it and compare. If you do, you can post an answer to your own question.