You can use your PIN to check out materials at self-check kiosks or to use resources like databases and e-books. Your password lets you access your library account online.
Think of it like banking: your PIN allows you to buy something with your debit card, and your password lets you log in to your bank account on your computer.