TLDR: Basically, there's a CCS adapter hidden in the Supercharger stall. If you want to charge a CCS car, all you do is start the session from your phone. The CCS adapter unlocks, and it's on the end of the cable when you pull it out of the holder.
I didn't notice it at first when I arrived, until I recognized the location from the video. It's really compact.
The word on the street is that the Tesla plugs will start speaking the CCS protocol so an adapter is trivial.