Xbox One just became the preferred platform for Fallout 4, and more importantly, for the Skyrim Special Edition out later this year. Which is a real shame, and a big win for Microsoft. That's what I get from the ' approve user mods the way they should work' phrase. but it appears that Sony had more restrictions still, and Bethesda decided that it had become unworkable.
Mod support on Xbox One is already a different beast from the anything-goes frontier on PC - no copyrighted material, no nudity, no child murdering, limited file size, etc. To read between the lines a little, it sounds like Sony was in support of mods on a theoretical level, but that the console manufacturer had too many restrictions for Bethesda to feel like it would be providing true mod support.