The Drake Equation definitely does "work" - indeed, the variables it uses are defined so it can't be wrong - but as you say, the numbers it uses are hard or even impossible to estimate.