First of all, is this a free or pro app?
This thread may be useful. Seems that storage limits are currently lifted on pro apps.
To answer your question, if you remove any reference to the url in your data tables, then that will cause the files to eventually be deleted. I’m not sure how quickly the storage amount is updated, but deleting the url form your sheets will delete the files from storage.