The main problem with spanning tree is convergence time. And, if proxmox vmbr bridge have spanning tree enabled, if you reboot a proxmox node, you'll have network errors during the convergence.
So, it's off by default for that.
But you can enable spanning tree if you really need it. (like for full mesh).
Another way, build layer3 point2point between each host, and use a vxlan to build the layer2.
(proxmox 6.2 have a new sdn feature (beta) with vxlan support)