Scottish Catholic attack on same-sex marriage 'may backfire'