Actually this is more of a point of information if you can’t rename or delete a Calc/Spreadsheet Sheet. If you are in “shared” mode then you can only add Sheets, you can’t edit or delete them.
So the simple solution is to log everyone off the document, remove the share, edit the sheets, then re-share it.