If i recall right (from a documentary or interview with roddenberry) is that he made up the equation (though he knew of the drake equation) to justify that aliens exist to the people he was pitching to. I guess they just didn't believe that many aliens would exist.