It doesn't make much sense, it is more of an idiom. It may come from "stayed IN bed longer" and then somehow transferred to "to sleep in". But you are correct, it to sleep in, means to sleep later than usual. I would remember it as an idiom.