Both options affect colors in a similar way, but I can't figure out the difference.
Saturation boosts all colours by the same amount whilst vibrance aims to boost the least saturated colours whilst leaving already saturated colours where they are.
The intent of increasing vibrance is to increase the apparent colourfulness of an image without overdoing parts that are already saturated, e.g. skintones.
Vibrance is used to saturate unsaturated colors more than already saturated colors, giving it a more even look. The image as a result is more vivid.
Saturation is used to saturate all colors evenly no matter what their saturation level was before. This can over saturate image in some area. An example is below
Original vs 0 % vivid. Notice the saturated yellow and green is still there
Original vs 100% vivid. Did not saturated the already saturated colors by much but look at the mountains, they were least saturated and now they are quite a bit saturated to give the image a more vivid look.
Original vs 0% saturation, notice there is no color at all. All colors are gray no matter what its saturation level was before.
Original Image vs +100 saturation. Notice yellow line is a little more saturated now but not the mountains which need more saturation but were saturate by the same amount as the yellow color.
In short vividness applies more saturation to less saturated colors while applies little saturation to already saturated colors.
The easiest way to understand saturation is if you're familiar with the HSL (Hue, Saturation, Luminance) colour space. The easiest way to think of it is a colour wheel - the hue is how far around the wheel you are, Saturation is how far out from the center of the wheel, and luminance is how bright it is. Saturation adjustments push all colours further out from the center.
EDIT - My understanding of vibrance was incorrect. See the other answer. Leaving it here for anyone else who shares my preconceptions