De-indexing removes the site from the search engine index, but not from the source web page. This means that the content still exists, but it will be difficult for someone to find the page in search results.