Why not stick to find?
See org-roam-list-files-commands – it’s a customizing variable to control which “search” executable to use. I don’t know how much of this standard way is applicable to Doom.
I think consult-ripgrep is easy to configure. Refer to this discussion.