any idea why distrowatch periodically goes down for days before returning.

My guess is it’s run as a hobby by A Guy “on his own time and his own dime”.

I mainly use it to find out if some distros have updates to their ISOs but I find it very annoying that quite frequently it’s down completely.

You might follow the RSS feed. Your feedreader would catch new posts whenever they are available.