I came across this post which seem to suggest any package that uses Requires.@require cannot be compiled into an app (as of 2020). Then I saw this issue in 2022 which seems to have fixed this problem, but apparently not for my case.
Ultimately I created my own forks of these packages and commented out all the Requires.@require statements (adding/removing dependencies as needed) for my specific application to work.