To delete user profile from local PC , Just update with -user.name and execute to delete
Get-CimInstance -Class Win32_UserProfile | Where-Object { $_.LocalPath.split('\')[-1] -eq 'user.name' } | Remove-CimInstance
To delete other non login accounts , Just remove -WhatIf and execute to delete
Get-CimInstance -Class Win32_UserProfile | Where-Object { $_.Loaded -eq $false } | Remove-CimInstance -WhatIf