I unzipped and then zipped:

SELECT
    boxes.box_id,
    ARRAY_AGG(contents.label)
FROM
    boxes,
    LATERAL FLATTEN(input => boxes.contents) AS item,
    contents
WHERE
    item.value = contents.content_id
GROUP BY boxes.box_id
ORDER BY boxes.box_id;