Haigh's replacement, former deputy London mayor Heidi Alexander, may concern Northern leaders who want an ally in Cabinet to make the case for investment