I didn't laugh nearly as much at Joe Flanagan's one liners as I did Richard Dean Anderson's.
It aimed at being a serious action show, with a comic relief reluctant hero (McKay.) But basically everyone spoke English, so that couldn't work right.
They also had villain trouble. The go'a'uld weren't hard SF plausible but they were still far more believable than the wraiths. The producers had convinced themselves that the foreign culture costuming of the wraith was stupid and contemptible (like all foreign cultures apparently.) They thought the new villains would be cooler. They were just generic instead. So none of them really had an undercurrent of genuine menace to sustain them as convincing threats, unlike the go'a'uld.