The joke is a play on words. Insomnia is when a person is unable to sleep.  The phrase 'tired of it' is generally used to mean 'I am bored with it' or 'I don't want to think about it or talk about it anymore'.  The word 'tired' is used because this involves sleep.
Last week I was diagnosed with insomnia , and now I ' m just so tired of it .