Tired is an adjective that describes the feeling of being in need of rest or sleep. It has a comparative form, more tired, and a superlative form, most tired.
When we want to compare two things, we use the comparative form. For example, "I'm more tired today than I was yesterday."
The superlative form is used when we want to compare three or more things. For example, "I'm the most tired I've ever been after running that marathon."