LOS ANGELES—Not even the Force can withstand withering reviews.

After mixed fan reaction and thumbs-down from most critics, “Star Wars: The Rise of Skywalker” took in an estimated $175.5 million in the U.S. and Canada over the weekend, the lowest opening of the trilogy produced by Walt Disney Co. The “Skywalker” opening, which theater owners had hoped would debut north of $200 million, is 29% below the 2015 installment “The Force Awakens” and 20% below “The Last Jedi” from 2017.

A...