Bank of Nova Scotia is the latest major bank to walk away from the industry’s biggest climate-finance alliance, following a mass exodus led by Wall Street.