Do athletes and designated athlete support personnel need to sign the CADP contract again?

No. CADP athlete contracts and CADP contracts signed by designated athlete support personnel are still valid, even if they reference the CCES.