> When I show a site like Lemmy to my non-technical friends, their eyes glaze over

That's quite understandable actually, the Lemmy UX sucks. Try showing them fedibb.ml instead. It's Lemmy under the hood, and federation works perfectly - but you'd never guess that!