In a criminal trial, why make a deal with the prosecution if the defense attorney is likely to get wind of it, and use it to impeach the witness on the stand?

It’s a common strategy in law procedurals, the case the prosecution builds is not tight, they make a plea, then almost invariably the defense attorney impeaches the witness with that. Then, for the record, the episode ends sometimes with another plea without knowing the outcome of the second trial.