Not particularly major though. He can no longer appoint or remove members of the executive committee, committee chairs, or the Deputy Mayor, but all current appointees (placed there by him) will stay in place. Council makes these decisions now.
As for the Emergency Management powers - the only thing it really does is make the Deputy Mayor the figurehead for response instead of the Mayor.
Any statutory powers are still in place. He's still Mayor.