Removing users from the database will completely remove the user from your own database. This is particularly useful when the users ask you to do so (because of GDPR, for example).
The second option will only remove users from the specified mailing list.