Even though this was a song and not real life, the things that Paula sang about are totally true. Opposites can, and do, attract each other all the time. What happens after that depends on how well the couple meshes in other areas of their lives and relationships. They can be as different as night and day, but if the love is strong enough and there are SOME things that they have in common, these relationships work out all the time.
Something to consider is that people who are completely opposite from each other can, many times, complement each other. They can make each other stronger and better as people. For instance, suppose there is a couple where one partner has a short fuse with a terrible temper and the other one is very laid back and rarely gets upset over anything. The partner who is a bit too laid back can often help the partner with the terrible temper. That partner can introduce calmness and stability into the relationship. On the other hand, the partner who is so volatile can help the one who tends to let people walk all over him or her. This works out quite well all the time.
Another area where this can work is by trying out the tastes and interests of each other. If one of you hates action movies while the other one detests romantic comedies, you can certainly compromise once in a while and try out a highly acclaimed film in both categories. Who knows? It just may give you both a new area of interest to enjoy together.
The idea behind relationships between opposite people is that they will balance each other in positive ways. If the love is there, and the attraction is there, it is very possible for other aspects of these relationships to work out nicely. Obviously, it will take some cooperation on both parts, but that does not mean it cannot be done. Many of the greatest relationships in history have been between two people who were so opposite from each other that there should never have been a reason for the relationship to work. Yet, these did, and were very happy ones.
In a relationship between opposite personalities, there are strengths and weaknesses. It is the meshing of these attributes that makes it all work. The weak become stronger and the stronger become a bit more mellow. In the end, what could be more perfect?