BUG: read_csv failure to convert dtype is not considered a 'bad line'

[nejail]

• [ ] resolves #63168
• [ ] Tests added and passed
• [x] Added an entry in the latest doc/source/whatsnew/v3.0.0.rst file if fixing a bug or adding a new feature.
• [ ] All code checks passed