Yeah, whether or not they are fired, because it is certainly unprofessional behavior, it isnt criminal. Unless you count that they were somehow putting the children in direct danger, but that probably isn’t the case for a geography or math teacher. Drunk woodshop teacher, maybe?
Oh yeah, reckless endangerment would definitely be appropriate, though if there were other teachers or staff reasonably close I could see it being contested.
Also, I absolutely do not condone being drunk at work as a teacher.