After further investigation, I am pleased to report that this feature is working as described in the documentation here: https://shopify.dev/tutorials/manage-app-translations-with-admin-api#storefront-api-translation-header
My mistake was to initially not use a sufficiently recent version of the Storefront API. This functionality works from version 2020-01 onwards.