Question
Why a 100μF capacitor, after being charged up to 6V, through a rectifier, by a repeatedly tapped piezo, cannot light up an LED?
Answer
Update 2021jan23hkt2150
To verify my guess that the capacitor has stored too little energy to light up the LED long enough for human to see, I did the following.
Find a big cap 10,000μF, and fully charge it up using a 5V PSU (Yes, actually we don't need the piezo! :)).
Disconnect PSU and let the capacitor alone supplies power to the LED.
I see the LED grows brightly in the very beginning, but as the capacitor begins running out of "steam", gradually dims and goes dead, after about one minute.
This is the YouTube showing the capacitor discharging to 1kΩ and LED.
Youtube Video of a 10,000uF capacitor discharging to a 1kΩ and LED
I found the testing of LED input voltage vs current and brightness a bit tedious, besides not very reliable. So I assembled a simple test rig for quick and dirty testing, as shown below.

Now I can test one combination of capacitance, V, I, brightness in less than 2 minutes. A very rough summary is given below:
For cap at 5V, the diode current with 1k series resistor is roughly 3 ~ 3.5V for Red, Yellow, Green, but lower voltage for Blue and White. RGY lasts longer, BW dies fast. Red is the most efficient.
For 10,000, 1,000, 470, 100uF, as expected big caps store more energy, so the LEDS grow loner. Very roughly, for 10,000, 1000, 470, 100uF, the light up time is very roughly tens of seconds, a couple of seconds (10, 5, 3) I surprisinglyly found that, even of the OP's cap value of 100uF, all my different types of LED can last 3 seconds. So I think the OP is not using super bright LEDs, or his caps are poor quality.
One very surprising thing is that I found the 1W RGB 350mA power LEDs, do not different from the ordinary low power LEDs, when testing condition is around 3mA. So I think 1W 350 mA RGBYW LEDs are very flexible, can be used as orginary LED at low current < 20mA, and can scale up to high power with up to 350mA.
One very important conclusion I jumped to is the following. Since LED current varies drastically as even small change in voltage, it is difficult to control current and brightness (which is linear to current) by adjust voltage.
So now I appreciate very much why CCS (Constant Current Source) is used in almost all of non hobbyist application and projects. So I am stalling my testing at this point, because I am diverting to learning and playing with CCS stuff, and only come back after I have build up confidence in CCS skills.
The OP's questions is a bit complicated and needs a long answer.
(1) If you tap the piezo sensor repeatedly, the piezo becomes a charged capacitor.
(2) Now the charged up piezo with, say negative end, connected to a capacitor through a rectifier, which lets electrons pass through but not allow them go back.
(3) Now you use a multi-meter and finds the capacitor charged up to 6V.
(4) Now let us look at the capacitor. The cap should have an energy of 1/2 * (C * (V\$^{2}\$)).= (100 * 10\$^{-6}\$) * (6V * 6V) = (100 * 6 * 6 * 6) * (10\$^{-6}\$) ~= 21,000 μj (Joule) = 21mj.
(5) Now you connect the cap to a LED, which should grow red, if there is, say, current of 5mA, passing through it.
(6) Now the starting discharging current should be big, something like V/R, where V = 6V, and R the "initial" resistance of the LED.
(7) If the initial resistance R of the LED is too big, then the current passing through, by Ohme's Law, I = V/R might be smaller than 5mA, so the LED won't light up.
(8) And even the initial current is bigger than 5mA, the cap might run out of electrons pretty soon, perhaps in 10μs.
In other words, if the LED lights up for 10μS, human eyes won't notice the flick of light.
(8) There are a couple of workarounds: (a) use a tight string, say guitar string to hit the piezo, then you might see LED blinking, as the string repeatedly hits the piezo, charging and recharging the capacitor.
(9) Use a oscilloscope, to store the capacitor discharging waveform, and display it back in "slow motion".
(10) Protecting circuit from piezoelectric disc voltage spike - EESE Q&A.
(11) Piezo sensor picking up audio instrument signal - EESE Q&A.