The act itself does not, it only gives the secretary of commerce the power to create regulations and other mandates related to any company owned by something that is defined as a foreign adversary, which in the bill is listed as Venezuela, China, Iran, Russia, the typical types.
Basically what would happen is, Bill gets passed.
The secretary of commerce, or some other figure in that range, talks to the president and they decide yeah, we need to ban those guys.
They talk to apple, Google, Microsoft, various cloud providers, and say "yeah, you're taking them off your store. You're also not allowed to do any business with them anymore".
I don't think it's likely they end up talking to ISPs to try to cut off the internet side of things, because that's going to take a lot more work and the people given power in this case aren't the sort to try to do that sort of thing.
So you're probably never going to be unable to access the website, they're just going to make it a heck of a lot harder to use it, and they're going to cut off all profit motive.