No this will not replace the null value. The logic will only tell if the column is empty or not.
If you want to replace the null/empty/blank values with phone number and email exist. use this logic in Assign activity.
row("Comments") = If(IsDBNull(row("ColumnName")) OrElse String.IsNullOrEmpty(row("ColumnName").ToString()), "Phone number and email exist.", "")