Yes, at least the version we see in the few available demonstration photos showing it running all the car's displays, because this simply can't work with phone dependency and projection. If you want a unified UI it has to run on the car, and new hardware will be needed, which is why no cars running it are being sold yet. Apple does make computers, you know. They design their own microprocessors, too. I hear they're actually pretty good at it.
None of this means Apple won't continue to develop a phone-based version of CarPlay, but it won't be the "next-gen" version being teased. In fact, they'll have to keep developing that version because next-gen won't be backwards compatible with cars on the market now, because the hardware isn't up to it.
And I sure wouldn't rely on CNBC for my technology information. They're guessing, and mostly do it very badly. Unfortunately the tech media isn't really doing a much better job of thinking this through. Not sure why. It really isn't so complicated.
That line is directly out of the Apple event by an Apple Employee and nothing to do with CNBC.