They're not even charging him with attempted murder, just assault. That will be plead down to disorderly conduct and he'll spend no time in prison once the plea is handled.
Not sure about Missouri, but in many states, there’s no such crime as “Attempted Murder”. Assault on a peace officer with some form of deadly weapon enhancement would be the usual charge.