Can VNC Connect replace Microsoft's Remote Desktop to allow multiple users to have their own session on a single Windows computer?

No. While VNC Connect can be used to connect to a user's Remote Desktop session by running VNC Server in User Mode, it cannot be used to create virtual desktops in the same way Remote Desktop can at this time.