What Rose did was expressly against MLB rules, which are clear about the punishment, a permanent ban. IMO, it was worse given his role as the manager.
However, I want to point out that as bad as MLB’s gambling “partnerships” are, it is just as much against the rules today as it was 50 years ago to bet on games. And I imagine the penalty would be the same.
If his name was Pete Jones, no one would care. That he was an exceptional player doesn’t change what he did.