More like crazy censorship that masquerades as anti piracy measures are incredibly short sighted measures by dumb governments that just hurt the honest users.
Pretty sure the pirates are all laughing their ass cheeks off right now.
It could, but it currently doesn't. Regulating and enforcing censorship is a lot harder when the offending material is not publicly accessible / easy to find. So even if you have offending content on your own private cloud, as opposed to have someone elses offending content on a shared public cloud, the censors would first have to find out about it.
If your connection to your private cloud passes through public internet, all bets are off. I don't think all companies have their private clouds at the basement level, completely owned data centers, connected via edge switches near the water cooler.
In my experience, a specific service in "The cloud" has an uptime similar to a single raspberry pi. Some services are more reliable, maybe upto three-nines.
If you design your systems as such - expecting them to fail, then using "the cloud" is fine. If a VM running in AWS goes down, fine, the ones in hertzner continue to work.
There's levels of availability you need -- what services can go down, in what geographic location, and for how long (do you need to go sub-second from all geographic locations? Because I'm not sure you can do that in any situations. On the other extreme are you happy with a TTL of 60 and failover to another IP, which barely counts as available in my book)