Well, your eye is most sensitive to green, and depending on the wavelength of the red LED, you're eye is quite insensitive. Also, your perception of brightness is not linear, so this may have some bearing on it.
I've connected a LED and resistor across a supercap and it was visible for several...