Hello,
it is basically the same as in a local Alfresco installation - only the Site Manager can delete a site. Unfortunately, a Network Administrator is not a full administrator and might not be able to assume Site Manager status in a site where the original Site Manager has been removed.
This might require a call to cloud support to address, unless there is a way that I don't know of.
Regards
Axel