It's not unreasonable at all to be sad that you have missed out on being a Mum and the visit highlighted and reignited your painful loss.
Most people would understand the loss- perhaps as your husband is trying to convey when he knows how you feel. That is he might have been trying to demonstrate empathy and understanding as he cares about you. No one, including your husband can know your actual feelings and how you are experiencing them internally.
Your question: *AIBU to have expected a bit more understanding when he knows how much I longed for a child of my own?*- is very difficult to answer as your expectations are unknown and unclear.
Describe to us what you mean by "a bit more understanding" and what you expect and hope for from your husband by way of his words and actions. As I don't know- perhaps your husband does not know? Meanwhile he is walking on egg shells regarding the forthcoming birth of this grandchild and in your eyes failing to meet your needs and expectations.
Starmer’s plan to ban under 16’s from social media
.