Besides the details mentioned in How to change field names, section, heading names and information messages article , there is one extra step needed to show custom label from language translation for experience cloud users.
For experience site users the additional language need to be added in the experience site builder as well.
Experience Site Configuration
- Go to Setup and search for All Sites.
- Open All Sites.
- Click on "Builder" for you experience site.
- In the builder view click on the Gear Icon from top left options.
- Select "Languages" subsection from the display.
- Click on "Edit Languages" add the required language.
- Publish the experience site.