Humans, Machine Learning, and Language Models in Union: A Cognitive Study on Table Unionability