So, it cannot be appealed? Great. What does the future hold for him? Can the state charge him?
It's basically the same as a jury finding someone not guilty. Once a case is dismissed with prejudice the prosecutor cannot appeal it and the defendant cannot be charged for the same crime due to the constitutional prohibition of double jeopardy.
In theory the state might be able to charge him, but it depends on whether or not there are state laws that could apply to the same set facts.
Perhaps the state will indict him and ask for a dismissal without prejudice so the state can turn him into their own pet politician. This is highly unlikely, of course. If nothing else, his value as a pet is nil given his impending loss in the next election.