The letters came from Korean beauty marketing and they were never standardized, so a BB cream from one brand can behave like a CC cream from another. That said, the products have settled into reasonably consistent habits, and the differences are real enough to be worth sorting out.
BB — blemish balm, originally. In practice: a tinted moisturizer with sun protection. Light coverage, hydration-led, usually thin. Sold on being one product instead of three.
CC — color correcting. Pigment chosen to neutralize a tone problem rather than just to match depth: typically more yellow or peach than an equivalent foundation shade, which is what cancels redness and sallowness. These tend to be thicker and carry more coverage than a BB, and some of them are full-coverage.
Foundation makes no skincare claim and is formulated purely for coverage, finish and wear, across the whole range from sheer to full.
For mature skin the CC cream is the most interesting of the three, because the two most common complexion complaints over 50 are redness and an uneven, slightly sallow tone — and a corrected pigment addresses both with less product than a foundation would need. The trade-off is weight, and weight is what settles in a crease.
If the CC half of this is what you are really after — a base that neutralizes a hue rather than just covering it — see best color correcting foundation for mature skin.
This page compares three hybrid categories against foundation. If the choice you are actually weighing is the simpler two-way one — a thin tinted layer or a real base — tinted moisturizer vs foundation for mature skin answers that directly.