Yes, the most common is the sex without a condom one, and it expanded from there. I've used "raw dog" in a few other connotations as well, most of them pretty benign :) It really is a fun phrase though. It rolls off the tongue. I tone down my vulgar humor for the audiences online!