Yea, pearl doesn’t show except in sun or direct light; metallics do if that was the effect you were looking for.
Metallics are base only AFAIK, and pearls can be in either the base or clear or both depending on what effect you are trying to get.
As for it comming out flat looking, that sounds like the Clear was mixed improperly.