"cd" in this context is an abbreviation for "CD," which stands for Cum Drenched. This means that the video features scenes with copious amounts of semen being expelled, especially during climaxes. The term is often used to describe very messy and intense sexual encounters.
"sissy" refers to a submissive, feminized male character or performer, who may wear makeup, lingerie, or other items traditionally associated with women's clothing. They may also engage in activities typically associated with female submissives during BDSM play.
Finally, "slut" is a term used to describe someone who engages in promiscuous sexual behavior and/or has an uninhibited attitude towards sex. It can be applied both to male and female performers, often with a sense of humor or lightheartedness.
So this video tag suggests that the video features scenes where a submissive, feminized male character is engaging in very messy, intense sexual acts and/or being extremely promiscuous and uninhibited about his sexual activities.