c2c: consider adding a retry policy around pts update

In https://github.com/cockroachdb/cockroach/pull/103834, we decided to surface pts update errors to the job level, which will then get retried. We should consider retrying the PTS update in the frontier processor, though its unclear what benefit this would have.

With https://github.com/cockroachdb/cockroach/pull/103834, we'll have the same behavior as CDC, though they are considering getting a smarter around retrying pts updates in https://github.com/cockroachdb/cockroach/issues/98585. For c2c, it seems prudent to see what CDC ends up doing and if our first c2c customers hit issues related to pts updates.

Jira issue: CRDB-28259