Do I have to give a DM automation tool my Instagram password?

No, and you should not. Legitimate tools connect through Meta's authorisation screen, where you grant specific permissions to a linked professional account and can revoke them at any time from Instagram's settings. A tool asking for your password is operating outside that system.