When people say, "I’m so tired it's not even funny" or "my head hurts so much it's not even funny", why would it even be funny in the first place?

I believe it is an expression used to described the intensity of what they are talking about. In this case, being funny is not intense so they are basically saying, "I'm tired and I'm not joking!".