Beware the sensationalism!
First: "it has reportedly locked the game's executable to Valve's Steam service forever and ever, preventing the just-released RPG from running on its own"
That sentence is essentially meaningless. Modding does nothing to the executable file, it only affects the data folder the game grabs it assets from as well as .esp and .esm files inside the folder. Mods still work with mod managers on top of Steam, much like how Oblivion, FO3 and NV all did.
Second: "Gamers are complaining that the new 18 MB patch has broken the unofficial "large address aware" third-party patch that allowed Bethesda's RPG to use more memory than 2 GB, support more modifications, and reportedly resolved crashing issues and texture corruption problems."
Remember that the rule of game modifications is that you must tailor your mod to fit the official product, it is not the other way around. Every time a game is patched the modding community needs to retest and recode any mods so they work with it, the developers should never have to work around third party mods when releasing official patches.
I'm reminded exactly like whenever Minecraft gets updated people need to reinstall a lot of their third party mods because the changes may collide with them. Its common practice, and I have a strong suspicion this article is fanboy-baiting.