They've actually fixed this hopefully this time around.

According to their blog post it actually has driver support for the RPi CM2 8MP (IMX219) and they'll be releasing their own Nvidia-sanctioned cameras available from their partners.

It should hopefully just work. No lowlight options at this time however, which means external CCTV is out of the question :(