Well done with your sobriety! Your wish to cancel the date for any reason you choose sounds sensible to me. I'm not sure how it could be considered irrational. Maybe you could explain this further.
Are you sorting through your feelings with regards to your husband's drinking and how to communicate these clearly with him? Or are you concerned about how you anticipate your husband might respond to a cancellation of date night?