I’m facing a similar situation. I want to tide up my AE project which also has multiple calls to the same videos.
My solution is to transfer all footage files into a folder inside AE project window. Then, when seeing a duplicated one I right click / Reveal in composition. Then ALT+DRAG so that I can get one with “used X times” on the project window and all the other copies unused.
After finishing this process I just do a reduce project.
Hope this helps.