The literal translation is "dick/cock eater," but in Cuban slang, it’s a term used to call someone an asshole, jerk, pest, annoying, naïve, gullible, or a fucking idiot. It has absolutely ZERO connection to the target's sexuality or orientation.
"Don't pay attention to that comepinga, he doesn't know what he's talking about."
When a female driver cuts you off the rode, on the way to church, while you are driving at the speed limit and she is going 20 miles per hour under the speed limit, once at the red light she continues by looking at you like your crazy and then you are forced to strain your voice box and advise her of her new title. "So Come Pinga"