The traffic is dropped due to a missing or incorrectly configured Access Rule.
Configure an access rule to allow traffic from the private Source IPs to the public IP of the destination.
Example:
The access rule should be created from LAN to DMZ with:
The access rule is matched before the NAT Policy is applied so when the traffic arrives to the SonicWall the destination IP is still the public even if the SonicWall already knows what's the destination zone.