Can't uninstall module that depends on custom field type in use
If a module define a field type, it can't be uninstalled if you have a field of this type. This is not related which tables are in the database, and deleting tables in the database wont resolve this.

What you need to do, is to delete the field yourself. Drupal doesn't want to this automatically, as it could mean data loss. From the message you get the field name taxonomy_term.field_yoast_seo. This machine name is structured as ENTITY_TYPE.FIELD_NAME, so the field you need to delete is on a taxonomy term. It doesn't tell which vocabulary it's located on, but hopefully you can find it manually and resolve it