How do I enable and use the password module for Drupal 6?
No, this module works as any other module. See my screenshot as I can see it in my module listing - 

Are you sure you have it in sites/all/modules/ ? Are the permissions correctly set?