I believe I've found the issue with with the missing in-game content from the Destiny: 2 Beyond Light Pre-Order Pack.
After inspecting the file information, I found that the DLC is missing its Package Family Name (PFN). A critical package/hash that allows the console systems API to register the game save data. Without it, the game can't identify the package.
-
Ooh, nice catch!