changefeedccl: investigate whether the kafka resizing behaviour is correct

For both the v1 and v2 sinks, we check for a MessageTooLarge error, which according to the kafka docs seems like it would indicate a single message being too large. Perhaps we should be using RecordListTooLarge.

Jira issue: CRDB-40418

Trace the v1 and v2 sink handling for Kafka's MessageTooLarge error, then compare that behavior with the Kafka documentation and the RecordListTooLarge error mentioned here. Done means determining whether the resizing behavior is correct and documenting whether the error check should change.

Written by the indexing model from the issue text.