It will take ages for that to happen. AFAIK the "ban" only really removes it from app stores, I don't think it even requires store owners to force it off of phones that have downloaded it already.
The data must be hosted in the US. Oracle will have to shutdown their servers.
It probably prevents them from distributing updates though.
Although TikTok has said they are gearing up to shut the service down.