No. Compression is the force that hold the backplate to the mounting plate at 4 locations. That's not relative to the discussion as it has 0 impact on the motherboard unless you tighten it to the extent that it crushes the PCB. Tightening down the mounting plate to the backplate also puts 0 clamping force between CPU and block / heat sink.
The force applied to the motherboard by the block / heat sink however is not compression, it's bending. Pushing down in the center, you have the slightly curved block pushing down in the center of those 4 posts. Here's a common image found in study guides for those studying for the PE (Professional Engineer) Licensing exam in structural engineering.
This simple beam image includes only 2 supports pushing up whereas we have 4 but I didn't have a 2 way slab / point load diagram readily available.
In the image, W is the force of the Heat Sink pushing down ... W/2 in the image (would be W/4 in our case) represents the force of the mounting bracket pushing up. Bending will occur in between.
It basically works like a gear puller.... or to visualize it better, think of two strips of aluminum 2 feet long. In the 1st one say 1/4 inch thick (representing the block / heatsink / steel mounting bracket assembly), drill three 1/4 inch holes, one at each and and one in the center. Thread the center hole. In the second say 1/8" thick (representing the MoBo), drill just the holes at each end. Fasten the two strips together with 1/4" bolts / nuts at each end. Now put a threaded bolt on the center hole
_|_________________V__________________|_
_______________________________________
The I symbol indicates the location of the bolts and nuts holding the two strips together just as the mounting plate / block / and backplate are held together with MoBo in between. The V represents the threaded bolt in the threaded hole of the water block / heat sink pushing down on the CPU socket / MoBo..
Now start tightening the center bolt .... the more ya tighten, the more that bottom plate is gonna bend.
Here's an image of the Phanteks air cooler. At this point there is compression load applied
Even when ya tighten down the two screws in the background and foreground, there is not much pressure applied by the heatsink to the CPU
However, when you tighten that middle screw, that presses the heat sink down on the CPU, a force which is opposed only by the 4 mounting points. Instead of the simple curve in the force diagram, the bending of the MoBo in this case is akin to to the shape of a square trampoline when you are standing in the center.
And yes, while a 2 pound block cantilvered off a MoBo is just fine for sitting on the desk, or even the back seat of ya car (my son's tower made 12 trips to college and back on his roof rack) I would never trust it to the FedEx gorillas who think Fragile means ... well let these guys show ya.
https://www.youtube.com/watch?v=LTiiS3Ze_GY