Does “disapprove” have any legal or enforcement effect?
If Congress passes a resolution to rescind the declaration AND overrides Trump's veto, then, yes, it certainly does. The emergency wold be cancelled.