This still doesn't really directly answer the question in plain English.

So would that mean Red Note would get banned as well?

If it gains more than 1 million active users and the president deems it to represent a potential threat, yes

Edit: assuming they, like tiktok, refuse to divest to a company based in the US

Edit: also assuming it is a foreign company. I’ve never even heard of it prior to this comment section