Hi Huy, thanks for writing this beautiful piece of post, very insightful. I see it a little different in case that we shouldn't disregard OLAP-Cubes altogether, but we should use newer technologies like Druid, Click House, Pinot, Kylin, or as you said, fully managed solutions that include this behind the curtains.
I wrote a little piece about it too last year, still up-to-date to some extend, if of interest, check it out here: https://www.sspaeti.com/blog/olap-whats-coming-next
Or my latest blog about data engineering approaches that would mitigate using OLAP-cubes. This post you can find here: https://www.sspaeti.com/blog/business-intelligence-meets-data-engineering/
Best Simon