I've not delved into modding BG3 yet but I do know it uses PAK archive format; Native Camera Tweak is dependent on Native Mod Loader, which are DLL loose files that go into root directory of the game. As such these files cannot be packed into archives and therefore the mod can't be offered on the official modding platform.

The point of modding support is so console users can gain access to a certain portion of mods despite the limitations. It will mostly be cosmetic mods, gameplay changes and gameplay additions, but any mod that depends on 3rd party files can't be ported over to consoles. And if Sony still doesn't respect its playerbase then Playstation users can expect not to even have cosmetic mods. It will mostly just be in-game changes, tweaks and additions based on what's already in the game.