If you're not logged in, nothing risque shows up. But, if you are logged in, and search for many kinds of image LoRA, e.g. "realism" or "natural skin", many, maybe most, of the example images would be R or X or XXX rated, even if it wasn't a LoRA labeled NSFW. I got bored of tinkering with image and video generation pretty quick, as it feels/looks weird, uncanny valley stuff, so it's been a while since I've looked at CivitAI, but even now after they did some kind of pruning of adult stuff, the logged-in front page has several scantily clad large breasted ladies (all kinds: human, monster, and anime).

I just poked around in settings, and they do have "hide" options for furry, anime, gore, and political, which is useful.