As folks have already noted, the NA Tesla connector is just a differently shaped connector for J1772 AC charging purposes. This is also potentially true for CCS purposes. Tesla just reused the same power pins for DC as they use for AC. Or, stated another way, the pins are oversized for AC use so they can also be used for DC. Tesla just uses a contactor inside the car to switch those pins either to the AC-to-DC battery charger for AC charging or directly to the battery pack for DC charging whereas CCS uses separate dedicated pins for AC and DC in practice (the J1772 spec theoretically allows low-power DC charging on the "AC" pins but nobody implements it).
All the control and signaling pins are otherwise the same between J1772/CCS and Tesla except that the pilot pin carries a different modulation and messaging framework when CCS DC charging vs Tesla DC charging. This "CCS" messaging protocol can optionally be implemented and used for J1772 AC charging as well but hasn't been needed so far and therefore today's cars use backwards compatible analog signaling.
In the future, J1772 and CCS are supporting a Tesla-style authentication capability where you just plug in your car and it self-authenticates to the charging station and charges without the driver having to use an RFID or credit card. I'm not certain, but this might be supported by some future J1772 AC chargers in addition to being supported by CCS chargers. In order for this to work, Tesla will have to support this CCS-style messaging on the pilot pin even via their J1772 adapter. The car will have to be able to determine whether to speak analog J1772, Tesla Supercharger, or J1772/CCS digital protocols over that pilot pin. I'm guessing they will find a way to make that work.
If Tesla can implement this pilot pin protocol support on the car then today's existing J1772 adapter can continue to work as a pass-thru adapter that just adapts the different physical connector shape. Likewise, a separate simple CCS passthru adapter would internally just connect the CCS high-power DC pins to the Tesla AC/DC shared high-power pins and the car would internally flip the right contactors when the car determines which kind of charging is being done based on the protocol handshaking and messaging on the pilot pin much Tesla does when using their native plug.
Aside from determining the right protocol to speak on the pilot pin, the only hard part here is adapting the locking mechanism which mechanically clamps the charging plug into the car during high-power charging. For both Tesla and J1772/CCS, the lock is mechanically actuated by the car (unlike CHAdeMO, I think). I'm not a mechanical engineer, but it seems plausible to me that a passive CCS adapter could internally contain a simple mechanical adapter that converts the Tesla car's locking pin motion into the motion needed by the clamp that CCS uses to lock the plug to the car.