This is all very client specific.

Some clients may weed your posts out of the feeds of those who follow the person who marked your post explicit, others may not.

Some clients have a way for you to mark your own posts as "sensitive content", others do not.

Some clients will automatically mark posts that contain certain words or hashtags as "sensitive content", others do not.

One of the things that is both fantastic and highly annoying at times is that there's so much variation from client to client on virtually every bit of how Nostr works.