Sharding across machines has faded as a concern because hardware got more powerful, not because the cloud made it easy.

But, at least this sort of sharding across multiple machines is maybe become less of a pressing issue just because more and more workloads can just run on a single machine. Some people still have very large-scale workloads that do have to be sharded across multiple machines. So, it's not going away entirely.