TL;DR
The pyramid captures the practice: most tests are unit tests (fast, low trust). Fewer integration tests (medium speed, medium trust). A few e2e tests (slow, high trust). Don’t invert the pyramid. Testing all the things end to end is exhaustingo.