The alarm won’t activate because forcing the binary_sensor to on doesn’t influence the physical alarm. However, you have confirmed that the suggested State Trigger is working properly, it triggers the automation and sends a text message.
So now we know the automation is functional and what’s left is to confirm the binary_sensor is receiving information from the physical glass break sensor.
Your testing of the glass break sensor suggests the glass break sensor is either ignoring the sounds you created or it does hear them but the Z-Wave integration doesn’t receive anything from the sensor.