Is the vendor user automatically deleted after completing their assessment?

No. The user remains active until manually removed via the Users page by a service provider admin or company admin.