Aurora (or just Google Play) volume measuring apps usually want network permission for downloading ads, i guess. It isn’t necessary for anything else, unless the app wants to upload your measurements somewhere. You can use any of these apps safely if right after downloading you forbid them from using network (or any undesirable permission for that matter).
Just go to the app’s page in your phone’s settings, where all installed apps are listed, click on “Permissions” or “Network connections” and choose “forbid” or uncheck all checkboxes regarding network.
I also checked F-Droid and couldn’t find a suitable sound measuring app. There are some but they all are not fit for your use case, except for one, Noise Capture. But even this one wants network permission! But for a good cause. You can revoke any permission from this one just like from any other app.