Exactly, getting started is easy but dealing with scaling and operations when it's deployed in a production environment is not simple, primarily because it doesn't separate storage and compute.
I think ClickHouse Cloud Beta addressed exactly this concern. It separates storage and compute and deals with scaling. There is no sharding so you don't need to deal with scaling.