I have a triple prospector double axe. I used it on spooky trial missions, secret missions, and regular missions and prospector did not trigger at all. I was on Apocalypse + difficulty each mission. I've linked a video that shows this.

https://youtu.be/BQpMTUdunQY