If we made the CCG (realistically, we won't, but just for argument's sake), a loss in the CCG won't keep us out. A 2nd loss during the regular season could keep us out (but outcomes this past weekend made that less likely to happen), but a loss in the CCG won't. They're different.
But, yes, a 5th or 6th seed is optimal, from the fan perspective. You get a home game against a beatable opponent in the 1st round. Then you likely get a very winnable game against the ACC or Big 12 champ in the 2nd round. After that, you're playing with house money ... anything can happen.