That is taken care of in most CMS’s, I believe. It will at least take you to a page. But – yes, the unpublished would be listed for a while in the SE.
Here is some food for thought, though……
I got really good rankings with Mambo with SEF (Search Engine Friendly URLS), but when I changed over to a website (all custom) I got more traffic and exposure. PLUS – more control over my content. I don’t use CMS’ anylonger. I write my own always.