Sudden Changes and transitions

My daddy has had dementia for awhile. He was walking and following directions while he was with my mother in assisted living. They actually were quite active. Unfortunately, they were not in a facility that provided good care. I received a call informed me that my dad's legs were swollen. I checked them and took him to the doctor. One thing led to another as I was informed that they must have been swollen for quite some time. Long story short, we ended up in the hospital. Turned out to be acute kidney failure. due to a very full bladder. Several days in the hospital where I, one of my brothers, or my husband was with him, and they still snuck medication (antipsychotics for schizophrenics) that had black box warnings stating how potentially harmful it was for elderly patients with dementia to him against our specific requests. Needless to say, he started hallucinating, getting night terrors, etc. It was AWFUL! Six days later, when he was released due to my begging the dr to do so as the hospital was having a HORRIBLE effect on him. He was completely unable to walk on his own. He would panic when someone abruptly tried to move him and has been not only bed or wheelchair bound ever since, but he cannot even sit up on his own. He has strength. For a while, with the right people and support, he would pull himself up, even lift himself up using the arms of his wheelchair at times, but now he's simply not mobile. He's still hallucinating. I am convinced that it was a combination of the drugs and horrible treatment at the hospital. While a handful of nurses and caregivers were WONDERFUL, a large majority of them were awful and borderline abusive.
Long story short, he still seems to have his strong intuition and seems to be able to sense when people have his best interest at heart and when they don't. I ended up moving my parents and changing their insurance after that. They're in a much better place but my daddy's condition has gotten to the point where we had to put him on hospice care. It is very difficult and painful. to see him in his current condition. He was always my "go to" for advice and support, and was also the only one who could keep my mother somewhat under control...
I don't know how hospice is supposed to work, but somehow, I thought it would help take some of the burden off...
It's difficult because I find myself trying to juggle my family, husband, kids, pets, volunteer commitments, and other commitments, while also taking care of my parents. Sometimes I wish that I had just made a financial arrangement to get a house big enough to house them and my family so that I could take care of them. I was too young to do much when they went into a retirement facility and was busy with young children when they moved to assisted living. Now, they're paying a fortune for memory care and assisted living. I'm going to need to come up with an alternative in the next six months as the costs will bankrupt them... Would love thoughts, advice, or suggestions on next steps...