This is a pun that is meta on the concept of being tired of sleeping, or getting sick of/being bored or sleeping. Feeling tired is also what you feel when you want to sleep, so it's an oxy moron.
Do you ever get tired of sleeping ?