It appears to be a good compromise; everyone wins, given the circumstances.
CIFUS's national security concern would be addressed since the data would be under the custodian of a blue-blood American company, Oralce. Trump wins because he can brag that his intervention has resulted in a US company landing a large cloud contract, and if Walmart joins the party, another blue-blood American company has its hands in the jar. It's even better one of the company is his good friend (Larry Ellison). The US Department of Treasury can even get a cut of the deal. For someone proud of his deal making ability, this one is for the history book. The American users win because they get to continue to access their beloved social media platform.
For the US companies that have been interested in acquire TikTok US operation, it would be a very difficult integration even if the deal come through, as Microsoft had said earlier in the negotiating stage, it would take at least a year to completely take over the codes and some even said it might take eight years. The success of TikTok is much more than the algorithm, even more than the data. It is their close integration of technology, data, process and organization structure that is the secret sauce. It has taken years and many trials-and-errors for TikTok to figure out how to make it work. Chinese government's step-in has supported and boosted ByteDance's negotiating stance, and gives everyone an excuse to take a step back and be more rational.
So everyone wins. The potential spoiler would be Trump's ego, because he has said repeatedly that TikTok has either to be closed or sold to US companies. If he feels a loss of face because the current deal does not go exactly as he demanded, he may still kill it.