If this successful of at least gain significant money (hint: it will because of the relatively low cost to make), Bethesda will change on modding framework in their next. Yeah it's unbelievable that they will intentionally stunted the feature that makes their game so big. It is also unbelievable at the time that Horse Armor DLC will become so commonplace today.
Why people like you are so naive? People at Creation Club are worked on contract basis. If they happened to make a good mod, they wouldn't get a fair share of their money. All of it go to Bethesda pocket. Creation Club IS underpaid outsourcing that masked as a benevolent attempt to make talented modders could get paid for their work. It is ploy to fool people who don't understand how labour laws work (hint: most gamers) and Bethesda looks really successful in this considering how many people naively believe they just give modders their fair share of money.
It is better for talented modder to setup for patreon rather than following Bethesda heinous scheme. Creation Club looks promising for modders...in the eyes of non-modders, while in reality it posed more problem than benefits. Just let this all slide and see future Bethesda game are built with Creation Club in mind.
Thankfully not all games with heavy modding scene is not like Bethesda. Despite that, their (old) modding community will be sorely missed.
Creation's Club relies on a modding community to exist to begin with. No, free mods are not going away.
And if you think your second point is true, why even worry? Surely no modders will take the deal if it's as bad as you say.