If that latency is low and your workload can handle disk concurrency well then it works fine. It helps if you use (or configure) a database with more sequential access and buffering for large updates rather than lots of random small writes, as well as spreading the data over several disks.
AWS EFS has latency problems which make it problematic but this product seems to have better performance profile which could work well.
I did a quick lookup in the MySQL docs (https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html) and was surprised that this isn't really an issue.
Learned something new, thanks!
You shouldn't use multiple servers writing to the same volume for database drives, but other than that it's no different than any other disk that might lose connection. Most VMs "local" disks are still attached over the network anyway, emulating a PCIe bus interface instead of NFS.