Any composition created in Pickcel console can be deleted using the delete option against it. But if the compositions are associated to any schedule/quickplay or set as default composition, then those can not be deleted and you will observe the below error :
In such cases, you will first need to delete the quickplay or schedule which is using the media and then you may be able to delete the compositions.