refactor: standardize _in_memory_table_exists

[ncclementi]

I saw this comment #10067 (review) from @jcrist and I'm converting it into an issue so we don't loose track of it.

Where is suggested to change the default implementation to:

try:
    self.table(name)
    return True
except TableNotFound:
    return False

This #9695 was merged
I'm not sure about the details of the implementation/refactor but this seems like it could be a nice consolidation of code