I was wondering if the database password actually encrypts the database, which would be nice for those databases with sensitive information like serial numbers and passwords.
No it does not. If you want a really secure database, make sure to disable Spotlight indexing and put it on an encrypted disk image. That’s the ultimate solution. If you search on the forum you’ll find more pointers to how others have tackled this problem.