In a Mirror, Darkly (2) - S4-E19
Stupidity: When the Gorn attacks Archer, one of the MACO officers raises his weapon to fire, but fears hitting Archer, so he doesn't shoot. But then he attacks the Gorn with the butt of his weapon. He was close enough to hit him, he could have just stood over him and fired without fear of hitting Archer.
Answer: While ratings did drop, there was a lot going on to cause the rating drops and cancellation. First, "Enterprise" was on UPN, which was dissolved a year after the show was cancelled. At the time of cancellation, it was UPN's highest rated drama. Because they were on at night, they were often preempted by local UPN broadcast of baseball games. And it wasn't even aired in every market. They also lost a major corporate backer early and it was difficult for them to over come that loss. Plus, for season 4, they switched to a Friday night line up, so they were competing against Fox shows, like "The Simpsons" whereas on Wednesdays they didn't have much competition.
Bishop73