I certainly don't know any more than what has been published, but based on that, I would support a fair and reasonable second chance for Herrera.
I generally support giving anyone a chance to overcome past bad behavior. In this case, the justice system was involved. Like it or not, without the testimony of the victim in the case, the prosecution had little choice but to move the way they did. I am not saying that is right but that is the way it is.
Then MLB did their investigation and review of the case and now has handed down its punishment under the agreement in place with the players association. The punishment handed down is, as Brookover points out, is at the high end of what has been done in other cases and far harsher than done to a couple higher profile players.
What happens next? The Phillies are prohibited from taking any punitive measure against Herrera under the system in place between MLB and the players association. Of course, that does not mean that they cannot trade Herrera or even release him, but it has to be and should be a "baseball" decision. Since Herrera's on-field play has declined and there was already discussion for a need to replace him even before this incident, the Phillies probably have sufficient cover to move forward without Herrera without appearing to be taking unauthorized punitive actions. They are on the hook for his contract that has a few more years to go. The issue is complex and I think it is important to handle it well.
Herrera seems to be doing and saying the right things. He has apologized, agreed to the suspension and loss of pay (two to three million), and declined to appeal the action by MLB. I have read that he is already in counseling. Assuming all goes well until the off season, I hope the Phillies do move forward and treat Herrera as a valuable baseball asset. I think the fact that the MLB punishment is significant coupled with good behavior going forward would make it possible for Herrera to play for the Phillies or to become a trade piece of some value. Of course, it remains to be seen how this will turn out.