What meaning does the nickname "Kyon" has?
According to RomajiDesu, it's a species of barking deer. It's humorous because the "n" on the end makes it sound feminine. Onii-chan is a token of respectful affection,  in contrast.

It's the contrast from being called (in all sincerity) "dearest big brother" and "Bambi"