If an automated message was sent to a guest for a reservation that hasn't been paid for, it's because automated messages are triggered when a reservation is confirmed, regardless of whether the guest has paid.
To prevent messages from being sent to unpaid reservations, add a message condition and include the condition "Reservation was fully paid". When this condition is toggled on, it ensures the message is only sent once the payment is received.