Rav Moshe was pro-Roe v Wade because in the system we have now, you can ask your Rov and base the decision on that. What would happen if your Rov paskened that an abortion is required (due to a mother’s life being in danger) and the government says no?
Personally, though, I’d be happy if the Court overturned Roe.