Your Super 'site name' (located in Site Settings) will only show up for you to identify your site on your Super Dashboard. This site name will not show up for visitors to your site.

The page titles visible on your site are taken from Notion, not Super. So, the page titles that you create in Notion will be the site name/title that your visitors will see.
If you'd like to hide your page title with CSS, you can do so with this code snippet:
div.notion-header__content.no-cover {
display: none !important;
}