If the Contracts (Rights of Third Parties) Act 1999 is used does this negate the need to Collateral Warranties?

NEC3 and NEC4 Contracts Secondary X, W and Y options
2

In theory ‘Yes’ as they serve the same purpose. As always, there are pros & cons to either approach which you need to match to your circumstances.