Maybe.
If you add columns not null with an actual default value, rows will be rewritten, so in that case, yes , then the old columns will be gone.
Otherwise no because the drop column is only a "logical" drop.
Only at maintenance time (rebuild or maintenanceplan) rows will be
rewritten according to the new columns.