Should not use `INSERT IGNORE INTO` in lightning tables

[joechenrh]

Bug Report

Please answer these questions before submitting your issue. Thanks!

#55477 changes INSERT INTO to `INSERT IGNORE INTO, which may case data correctness.

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

[joechenrh]

/severity moderate