Kudos to your husband for continuing being sober. Try to help him with that. His penis retraction has nothing to do with his drinking problem. Does he get morning erections or at other times? You don't mention his age. He should avoid Viagra at this time and consider other options. If he is overweight, that can give the appearance of penis retraction.