I’ve used it a couple times personally, and I once used it with my family, though my dad booked it that time. For personal use, I just get a room in someone’s house. For family, we got a house to ourselves.
Getting a room can be a bit weird at first. I felt like I was invading on a family, and as nice as they were, it still felt weird. The second was a bit less awkward, but it was annoying to have to share a bathroom and microwave. In the end, I tend to prefer booking hotels through Expedia. It’s easier than Airbnb and can be bundled with my flight. In the end, I might pay a bit more, but I find the overall experience more pleasant.
For families, though, I think Airbnb is great if you get a house. It can still be a bit weird at first, but I preferred that over cramming everyone into two hotel rooms. It also means your kids are slightly less likely to keep all the neighbors awake. That wasn’t a problem for my family, given that my brother and I are adults, but I have talked to people for whom that’s a major reason to use Airbnb.