Your question pertains to the subject of "Statics"; the study of structures in static (non-moving) equilibrium. By the nature of your problem, no component of the assembly is moving. Good - so let's study it using the principles of statics.
One can take a slice (called a section) anywhere on the structure (say, the rope), and consider the forces on each side of the section. Because the structure is static, the forces will ALWAYS be equal and opposite. (If they weren't equal and opposite then there would be a net differential. Such a differential would propel that section into movement, as in F=ma.
What you had done in your opening statement was to sum the forces around both sides of the section; therein you got zero. Good, as it should be. When the sum of the forces at a section equal zero, then you have proven there is no net force remaining - thus the section is in static equilibrium. So, there must be no movement.
The above could be merely an exercise in accounting. If a lender borrows $100 from a bank. Then the lender has +$100 while the bank has -$100; together this financial system has $0 money overall. It would be wrong to take the absolute values of both moneys and say the system has $200 in it.
Note: if there is movement, then one has moved into the realm of "dynamics" - the study of structures in movement. In that case, there would be a net force once you have summed around a section.
One could ask what is the point of determining the forces at a section for statics, if you know that the sum of the forces equal zero. Well, what is of interest is the magnitude of the force on one side of the section. That level of force is often what is of interest, such as when designing the necessary strength of the rope in supporting the intended weight below.