This is a generational aspect that hasn't formed in living memory and won't for a long time yet, because Neptune and Pluto move so slowly. You'll mostly meet it in historical charts.
For the generations born under it, it marked a tug between ideals and power, often played out on a large stage, with beliefs and those in control facing each other across a divide.
At its best an opposition like this teaches a society to balance vision and responsibility. If you're reading a chart that has it, look for a person who lived through a long struggle over what to believe and who should decide.