If tooltips are on with no key modifier required, they show in the Adventure Guide for dungeons and raids perfectly fine, like so:

However, if you have it set to require a modifier key, such as Alt, the tooltip integration does not appear, even if the modifier key is held:

It seems like maybe the Adventure Guide frame is rejecting modifier key inputs?