One subsite not loading

One of the subsite in the multisite isn't loading, the homepage is loading without stylesheet with many 404 error requests in the console, and the back-end is loading the following error:

redirected you too many times.

Please check the chat notes for more info.