Add product tests for ensuring event listeners loading

[ebyhr]

To catch initialization failure, e.g. #22228

[alprusty]

Thanks for raising it @ebyhr
I also realized that we don't have product tests to capture event listener initializations while fixing the recent open lineage event listener loading issue #22228

I would be happy to collaborate on this.

[Praveen2112]

PTs were planned as a follow-up as the PR is getting quite big. Thanks for opening it out @ebyhr