I know most hospitals don't have a lot of social services on weekends but hopefully they were able to give you some leads. Back when I was homeless there were some shelters that had rooms for couples and families especially those that were dealing with medical and mental health problems. I think it was the ymca that had a seperate floor for those they called vulnerable both you and your husband would qualify for that.
You are absolutely not a drama queen.