`substreams sink noop` metrics: `head_block_number` glitch

`head_block_number` gauge glitches occasionally


<img width="1224" height="354" alt="Image" src="https://github.com/user-attachments/assets/749d044b-646d-43f7-ba79-b7ea5c3d3f3b" />