The research emphases in counseling psych tend to fall in vocation, contextual factors (i.e., gender), multicultural, process-outcome (e.g., common factors), and supervision. In clinical, it's much more common to find PIs with dedicated research programs on various areas in bone fide psychopathology, neuroscience, and clinical assessment. As others have mentioned, there can be considerable overlap depending on the training program. It's also not that uncommon to have clinical psychologists as faculty in a counseling psychology program so YMMV.
IMHO, it's mostly program dependent from a practice standpoint. It's probably more important that the program in question has good relationships with external sites that offer quality training experiences. My alma mater had several counseling grads in the local AMC so we were actively recruited as practicum students, which led to opportunities to get training in different subspecialties. There were also a few working in the prison systems, which offered folks forensics training so again YMMV. That said, clinical practice in sports psychology seems pretty heavily represented by counseling psychologists, at least from my perspective. I think it's because many athletics programs have relationships with the university UCCs, which has strong historic connections to counseling psychology training.