If I understand your question correctly then yes, other VMs will be able to access the data. SSE is is encryption at rest so protects your data if the storage drives were physically accessed by an intruder.
https://video2.skills-academy.com/en-us/azure/security/fundamentals/encryption-atrest