No, it's not insulting. It's an old-fashioned slang word for a man. I believe it comes from the 1930s, used to refer to jazz and swing musicians. That's why you'll usually hear it in the phrase "a cool cat" - someone who's stylish and cool, usually in a retro style.