National Highways said it completed a 'feasibility' study on replacing the A5036 footbridge but found it would be 'unaffordable'