If a website is concerned about that case, then instead of letting it inform their URL design, they should have a "Warning: Adult content. [Continue] [Back]" interstitial like Reddit or Steam.
Since you bring up Stack Overflow, notice that they do the canonical redirect. Change the title in the URL and you'll get redirected.