A passenger known to have been intoxicated in the terminal at Springfield, Missouri, was permitted to board a Delta flight to Atlanta. During the flight, the passenger became unruly and made suicidal statements leading to the flight diverting to Huntsville.