Is After Effects capable to show me every asset in the projects library that is NOT used in active comp? Is it possible to delete all unused assets in the projects panel from after effects?
With the desired composition selected in the Project Panel, go to: 
File > Dependencies > Reduce Project: