Totally happy to have a conversation, particularly since I also have conflicted feelings on the question. :)

So the way review works now, the Court can find a law unconstitutional, which sets a "do not enforce" precedent. The can also hear a case involving executive action, and find an order or act unconstitutional and force the executive to stop.

Neither is explicitly in the constitution, and there's a lot of documentation by the founders about if it should or shouldn't be.

Totally abolishing judicial review would mean the courts would only be able to rule on the law as written and decide court cases without determining the constitutionality of said laws.
I don't think that makes much sense, since deciding questions of law requires interpreting applicable laws, and the Constitution is one of them.
It would also leave Congress to decide if their own actions were constitutional, which isn't great, but also isn't too different from the supreme court, with the perk of public accountability via elections.

I'm more in favor of a reduced judicial review, where the courts wouldn't have the power to restrain the executive or legislative branches, but would have the power to decide cases, set precedent, and determine constitutionality of laws, but not "categories" of law.

In the case of Roe, it would have played out that the Texas law would be decided against Texas, but that wouldn't generalize to invalidating Mississippis similar law. Precedent carries weight, but not the same weight as striking down or invalidating a law.

It cases like "Ohio vs EPA" (Ohio sued the EPA because the EPA said that air pollution that leaves your state is subject to interstate regulation, and set a plan for reducing those emissions. The court ruled that reducing emissions would cause irreparable harm to the states being forced to curtail emissions) the Court would be able to decide the case, but they would not be able to order the executive branch to restrict or change how they execute the clean air act as directed by Congress.

This would have the effect of increasing the number of court cases. Also of making it more difficult to stop an executive whose interpretation of a law with delegated congressional authority is wonky.
It would lessen the courts authority to do things like establish corporate personhood, establish money as speech, or decide the president is (largely) immune from prosecution.

It's a mixed bag. Historically the courts have done much to advance individual liberties and a general progressive sense of justice. But they have also, in deeper history and more recently, done much to hinder it.
The opinion of (some of) the framers of the constitution that entrusting effectively unaccountable power in the trust that a small group of people will remain unbiased, nonpartisan, and objective for the duration of a lifetime appointment is choosing a kind of oligarchy is compelling.
We spend a lot of time as a country hoping that we have a "good" court, and worrying about what they might change about our society in their next ruling, with very little prospect of being able to influence or overrule that decision.
In a democratic nation, people should not have to say "oh, our legal standards for abortion access have suddenly changed, we better find a way to work around the ruling until a new court can flip it" rather than trying to clarify or pass a law, remove the people who misrepresented our wishes in the next election, or take the ruling as a new precedent and not a definitional shift in our legal structure.

There are good arguments for a largely unassailable court that's not beholden to public opinion.
The only other way to make them not an effective oligarchy is to reduce their power.
Anytime power rests with one or a few, you'll have good and bad decisions, depending on the quality of the ruler. Reducing their power reduces both, but it shifts it to more democratic systems, which at least we have feedback on.

At some point while writing this I got an increasingly bad headache and went rambly. Sorry about the wall of text, but hopefully it's an interesting read at least. 😉(Pretend it's not a wink but smile with a migraine wince)