Already moved. It has been a bit of a journey.
As with many IT innovations phase one is trying to do what you are doing today with new equipment and not realising that new equipment allows radically different approaches.
We are moving more to serverless applications, SaaS and PaaS. Serverless apps offer the greatest flexibility but getting the boundaries and interactions right is a challenge. The number of DBA roles has decreased but not necessarily the number of people. Some DBAs want to continue to pursue the career of a DBA, others have decided that a broader data engineering role is their future.
Multi-cloud tenancy is also emerging. Not 100% convinced by that although Google Anthos seems to be paving the way.