Your example is almost correct, but uses a non-existent hook. This is not considered an error by the interpreter because hook variables don't have to be defined before adding a function to them, this allows customizing them before a package has been loaded. The correct example would be as follows:
(add-hook 'org-log-buffer-setup-hook 'evil-insert-state)
I found this hook by looking through the Org sources. It should be possible to find it by consulting the documentation as well, however I didn't manage finding either org-add-note
or org-log-buffer-setup-hook
in the Org info manual. Therefore, your only realistic chance would have been to check out M-x customize-group RET org RET
(where it's one of the first variables) or doing the same as me (and look for defcustom
with a hook type in the sources). Perhaps you'll want to report an Org bug to remedy this in a future version, this can be done with M-x org-submit-bug-report
.