I’m not sure that opposites necessarily attract (we’re not talking about magnets…) but too similar is usually NOT good for family stability. Although disagreements and different styles may cause some friction, you wouldn’t for example want both parents to be strict disciplinarians.
The example you mentioned is probably better than the reverse as there needs to be at least one practical spouse, however people do adjust and mature to do what’s necessary so even 2 “studious” partners should be okay. (If you’re just talking about studious while in school/yeshiva it’s a total non-issue.)
So bottom line they needn’t and probably shouldn’t be the same but their personalities should complement each other.