fix(messaging): improve MessageQueueTrigger logging and add comprehensive tests

https://github.com/apache/airflow/commit/339daf6bc070976e9bc5a844b4ef1b1e30b1357f