Yes, it's heartbreaking. I try to focus on the positive outcomes of dogs in loving homes...and on the fact that for a while at least the dogs who don't go home were loved and safe. For a while.
I started volunteering at shelters in high school and continued through college. Prior to the start of this current shelter's behavioral/training volunteer program, most all the dogs that we have worked with through that program, would have gone to the Bridge instead. There was no behavioral department. So far we've had a few hundred pass through this program and have been adopted. A couple of years ago we had a pregnant mom surrendered on the eve. of what turned out to be her whelping - 13 puppies. She and babies were fostered at the Behavior Department Manager's house. I and some other volunteers spent time helping to clean and enrich the area where they were staying and took part in infant puppy socialization and first learning experiences. It was so amazing and powerful to see the impact of the handling and work with 1-day old puppies..,and to see most of that same litter as adults, a year later, at their year-old party at the shelter. Mom was at the party, too and yes, she was spayed. We have video at home here hub took when he went with us to that foster person's house, to help out and we all took the puppies on their first walk outdoors.
With those two I mentioned in the last post, I know the shelter reached out to various rescues and I personally spent hours calling around to try and get them into rescue also and there was just no option. It was emotionally very, very tough, being my first dogs in this setting, to lose. And a Rottie, too.
Since then I've worked with quite a few dogs whose time is limited and are in quarantine for bites. Not biting because they're "bad dogs" but because..stuff happened. Often on their last day I bring them something special, like a burger.
I'm glad your shelter is doing a good job and has those resources. We have something similar - adoption events "on the road" for the "general population" dogs and then with the dogs in my specific program - dogs who -can - go out to to public venues, I and others have taken a few out, wearing their "Adopt me" vests. Sometimes I take them to the dog bakery in the area, or to an outdoor seating spot like at Starbucks or something. We had a sweet older Hound-mix male who I took to our home and let him explore our yard, as we had agility equipment out there <not up in the new house yet> and it was a very woodsy/"brush-y", large yard for an urban lot, and that way he got a nice car ride <he enjoyed riding> and got to smell around our yard and see some new things.
We have a few dogs currently in foster, of the dogs in my program.
We also have tons of kids' activities and clubs involving humane education.