When you publish a CSV as a hosted feature layer, you get a button on the item page called "Update Data" where you can load in a new CSV to overwrite the data as long as the schema matches. This option should be available for anyone with editing privileges, or at least some role below administrator. There are plenty of workflows where I might create a hosted feature layer the first time and then turn over maintenance of the data to other people. Not being able to maintain data in a CSV and then batch upload it is a big drawback. If you trust your users to edit your data, you should give them all of the tools they need to do the job.