Apple never brought it back to the App Store. TikTok has to be sideloaded in the US: https://www.bbc.com/news/articles/cqldw5y4y0no