A prosecutor trying to optimize for conviction rates will still refrain from prosecuting people when he doesn't have a good case. It's just based on the quality of the case, not the presumed guilt or innocence of the accused.
My point of eyewitness testimony is that it would truly convince the DA but wouldn't be valuable evidence in the trial. They could say "I think I saw him elsewhere" to be truthful but say it in a way that didn't give it enough weight to counteract the other, conflicting (because you weren't really there) evidence.
If this came out, the DA would not even face censure or reprimand, let alone firing or criminal charges.
I don't know the hand-ranking of various legal maneuvers but I am curious where a DA's eye-witness testimony would rank compared to a cell-phone location trace, or hair samples, etc.
Because this helps society?