Will the musty smell go away right after remediation?

Usually, yes, once the mold and any affected material are removed and the area is fully dried. In some cases a faint smell can linger briefly while everything finishes drying out, which is different from the smell returning.