In the previous video of Site Master creation, we understand that the Site profile of a site can't be changed once the Site is created. The same is validated in the SAP Help site also. However there are chances of manual error while creating a site. E.g A site which was supposed to have created as Distribution Center could have been created as Store and when the mistake is realised, we should be ready to face subsequent consequences like breaking of number (range), confusion from the Business as they might have been using this site already but couldn't adapt to the new number etc. In such cases, we should find out workarounds to fix this.
Luckily there is a workaround to change the Site profile of a created Site. However the drawback is that you will not be able to delete the vendor / customer of the created site, so you should consider either archiving the same or set a deletion marker.
Take a look at this short video which could be even an adventurous fun activity rather than fretting with a mistake.