Supporting a 'forgot my password' option is possible, but there is currently no built-in feature to achieve this.
However, you could build this solution by using Airtable Automations or a third-party tool like Zapier. You would need to let users submit a request by filling out a form. And then automatically send them an email with another form allowing them to set a new password.
Alternatively, you could add instructions in the description section of the login page asking the users to email the admin (you) for help.