Yes, I completely agree with your assessment. For this reason, I prefer separating workloads. Cloud providers make this really easy with managed sql and key value datastores.
In datacenter there are good options using high availability storage arrays and vm systems. I don’t see that kube was ever meant to replace that for this workload type.
I know some have this overly simplistic idea of “one platform only”, which I don’t agree with. I see no reason not to use the correct tools as appropriate for the task at hand.