There will always be a hobbyist segment of the market. For these people they like the difficulty of integrating a PC system into the car. There's also the whole retrofitting of older cars with newer technology, so the "Death Of The CarPC" is not so much a death as it is a repositioning in the marketplace and much smaller market share than it already has.
I for one, like where the market is going. I think the Head Unit as we know it death is coming, not this year but within 5 years. OEM's are finally starting to give consumers the types of products we want as far as infotainment is concerned.
I really like the Parrot Asteroid car stereo. Especially for older cars without the natural dash opening to have Double DIN units. The display is about as big as my 3.5" JVC In-Dash Navigation HU, but with way more function and with better Navigation software based on Google Maps (Parrot Maps).
Plus it has USB ports on the back for use with USB devices not just as a port for audio playback. Its way smaller too since it has no internal media drive and likely has flash memory instead of a actual hard drive or a very small SSD. If its flash memory that will keep the cost down, if its SSD, it will be fairly expensive.
Anyway, I don't think death is near, it was never really fully alive to start with. Too many people feel putting a PC in a car is far too bulky and expensive with miniaturized hardware (and specialized software). I mean try to get people to think of their PC's as replacements for their cable or sat provided DVR's and you'll get a blank look in return.