Also shooting with medium format film, it allows me to get higher resolution than a similar priced digital camera. Digital Medium format cameras exist but are significantly more expensive compared to an old film one.
Certain film cameras in good condition are getting hard to find, so they either hold their price or go up. Sometimes if an influential film camera blogger mentions a particular camera that too can cause the prices to spike as well.
I've often heard a comparison to using film is similar to vinyl records.
They're certainly not 'useless' - this camera with good film should resolve a similar amount of detail as my Nikon D810 with a good lens. Obviously given the inflexibility you wouldn't use it for, say, photojournalism or most types of commercial photography, but medium format film is still used a lot in art photography and portraits.
Unless you're really consciously going on a photo-taking trip, you're generally not carrying around these huge old mechanical cameras, getting the film developed, etc. Every step of the process is more involved and time consuming -- where are you getting the negatives/slides printed afterwards?
Unless you're a high skills photographer, it just doesn't match people's use cases these days. Also, I've seen friends take up medium format as a fad, but they generally lose interest after a year at most.
That said, I borrowed an old Bronica several years ago, and I enjoyed it a lot. There something so satisfying about loading that film up, winding, exposing, and getting your hands wet on the chemicals, and having a big negative to look at, with sharpness outdoing anything you see even today in digital.
Alas, even now, that gear still sells for $500+ (even broken stuff) on Ebay, I can't bring myself to buy one. How is it still retaining its value? Just like Leicas. Who's taking photos and getting film developed that gives it strong market pricing? Nostalgic people unwilling to admit the camera is useless anymore? A puzzle.