Live pages can be seen by anybody and by the search engines.
Draft pages can only be seen by logged in CMS users. Draft pages cannot be seen by non-logged in visitors, nor by the search engines.
Hidden pages can be seen by non-logged in visitors. They can be accessed by anyone with a link or the page URL. Hidden pages automatically have a robots.txt file and therefore can not be seen by the search engines.