If you have a list of URL in OpenRefine that are redirected and for which you need to get the target url, you can use python to do it. By adding a column based on the column containing the URL and using the following jython code :

import urllib2
res = urllib2.urlopen(value)
return res.geturl()