I entered a 2nd shipping profile on offer creation. What effect does this have?

Currently it has no effect. The secondary shipping profiles are not used yet. We plan to implement this option for our customers at a later time.