Content Query Web Part Not Showing Events and other List Types...

You have to enable the Team Collaboration Lists feature on a WCM site in order to get a fully populated Show Items From This List Type drop down when using the Content Query Web Part. If you don't have that feature enabled then the Content Query Web Part only shows you a subset of list types to pull from and that does not include calendars & etc...