scripts/title: follow redirects first

Before we try to do site-specific info look-ups, we are now loading the
URL to follow any redirects. If we don't need to use a site-specific
fetch for the page we end up on, we keep using the last data we got.