You can't be tried multiple times for the same incident.
You can be tried by both the federal and the state governments, separately, on the same charges (that is, on equivalent federal and state charges).
I think you can be tried for the same incident, by the same government body, on different charges.
Yeah, reading through the wiki on it, it appears you are correct. That usually does not happen just because it's costly.
Seemingly most things that are technically illegal are rarely enforced because it's just too much work and not severe enough to be worth it.
Littering?
Another, similar case[0] was also brought, in Massachusetts some time ago. And there were, at least temporarily, some negative impacts on the defendant[1].