I don’t think CC is the issue. Look at California, etc.
I think the issue is - do you want your son to have a 4 year residential experience or a two year experience ?
Also, many but not all kids get their first internship after 2nd year. Some first but most second - not all but some. The kid has to want it.
That likely won’t happen from a CC.
I’m not a two year fan personally unless there’s an affordability issue.
I’m sure both UVA and VA Tech can provide you stats on CC transfers.