It is, at the moment, unclear whether the Community folder will ever be available on xbox. Xbox uses the marketplace exclusively right now and is, I think, the way it will always be. To do otherwise risks code that has not been through the MS xbox vetting process being able to be run on the xbox, which is not allowed today for any title.
Mods sold through the marketplace are stored in the “Official” folder and not the Community folder, and so the user never has a need to organise these through some kind of file structure and therefore no need to be able to manipulate these through an “xbox explorer” (which doesn’t exist anyway) as it can all be managed through the content manager as is today.
In that sense, the devs have clearly thought through the design to be able to work on both xbox and PC.
None of which makes this an xbox title designed for xbox that happens to run on PC. It has been designed to run on both from outset, which is the same as all windows “play anywhere” games.
This is one of the areas where the PC and xbox titles differ. The others being things like the graphics fidelity capabilities and ability to be able to connect to external software (like FSUIPC, LNM etc) which is also currently not available on xbox. So definitely not true to say that if it doesn’t work on xbox it won’t come to the game…it already has.