I personally don't have any problem with women taking part in the ordained ministry. I know that as with the Orthodox, the church has decreed (mostly on the grounds of tradition) that it has no authority or power to ordain women, and this was endorsed by John Paul II. Because of this, many Catholics feel the matter has been settled for all time. On the other hand, it is clear both in the scriptures and also in the history of the church that women have been important, both in salvation history and also as ministers in the church. Unfortunately though, there has been strong prejudice against women in the church down the ages, and that can be seen also today in some of the more hysterical rantings of conservatives in various churches who seem to really despise the idea of women doing anything much at all and would prefer that women 'be silent and not teach' as the author of the Epistle of Timothy urged.
There are many examples of great women in the church. Mary is perhaps the prime example of a great woman but there have also been many great women saints in the church (i.e. Julian of Norwich, Metchild of Magdeburg, Joan of Arc, Hildegard of Bingen, Teresa of Avila, Teresa of Jesus, Benedicta of the Cross, Mary McKillop, etc) whose lives have been examples of holiness and authentic life in Christ without them being ordained to the priesthood. Today of course we have many women who do positive lay roles in the church, or who are religious, or teach theology. I think the church should, if it feels it cannot ordain women, do more to encourage lay women to participate more in various ministries of the church, particularly in light of the serious priest shortage.
Ultimately it is a decision each church has to make. Even so, women used to be excluded from most professions and also from university education. The fact we have accepted women as corporate CEO's, scientists, university chancellors, judges and leaders of nations in my view also means that we should not exclude women from the roles of highest importance and power in the spheres of religious leadership.