Just came across this topic while looking for such a data explorer query! Has anyone created one yet?
The UI for managing themes and components has been improved dramatically since this topic was started. The components list shows all the themes each component is used on:
