"Command find requires Authentication" despite having correct authentication details in mongoURI

I would guess you have not correctly set up roles for the MONGO_USERNAME.
A user can log into MongoDB but not be able to do very much if the user does not have certain roles.
If this is your problem, see Built-in Roles and Create a User.