A load-bearing wall is holding something up: floor joists, another wall, or part of the roof. Removing it does not remove the load. It means the weight has to be carried by a beam instead, and that beam has to deliver the weight down to posts, and the posts down to footings that can take it.
That chain is why an engineer is involved. They size the beam, specify the posts, and check what is underneath them. In many houses a new footing has to be poured in the basement directly below each post, because the existing slab was never designed to carry a point load.
During the work, temporary walls are built on both sides to hold the structure while the old wall comes out and the beam goes in. The beam can be dropped below the ceiling or set flush inside the joist space, which costs more but leaves a clean, flat ceiling.
Expect a building permit, a framing inspection, and some rerouting of whatever was inside the wall, often wiring, ducts, or plumbing. Done properly, it is routine structural work. Done without drawings, it shows up later as sagging floors and cracked drywall upstairs.
