The video that made it all come together for me was this "Dance of the P-Values" video:
https://www.youtube.com/watch?v=5OL1RqHrZQ8
It does a great job of showing how the same experiment can yield vastly different p-values and why it's not useful for the task it's been given.