The 'Visible on Catalog Pages on Storefront' attribute property determines whether or not the attribute value is displayed in the Additional Information tab on the product detail page. If this property is set to 'no', the attribute value will not be displayed.

For a custom product attribute to be displayed in the Additional Information tab on the product detail page in Magento, it needs to be visible on the catalog pages on the storefront. This visibility is controlled by the attribute property 'Visible on Catalog Pages on Storefront'. When this property is set to 'yes', Magento includes the attribute in the Additional Information tab, making it visible to customers browsing the product. This setting ensures that only relevant and intended attributes are shown on the storefront, allowing for better product information management and customer experience.