Why would they give C away for free when one buys Y, unless they had to? Isn't that an incentive not to spend the $$ on C? Kind of against the purpose of having a C cabin, which is to be able to charge more for it?

Yes, operational upgrades are there for operational reasons, i.e. they would deny passengers in an oversold Y boarding, so they utilize unsold C seats for it.