Pico W HiveMQ Cloud and Node Red issue

have you confirmed with a tool such as MQTT explorer that the message goes through HiveMQ.

Also check this :