Does the yacht have to be on the Commercial Vessel Register to be able to Charter?

No, the vessel may remain on the Pleasure Yacht Register, but the yacht must have valid Large Commercial Yacht Certificates appropriate to the size of the vessel and be manned in accordance with Cayman Manning Regulations and LY3 requirements.