no-hit wondered

adj.

Sufficiently drunk to sustain a long career in the pub without producing a single successful conversation.

Lislie became no-hit wondered, remaining commercially popular despite contributing no memorable remarks.

Source: Wiktionary