Honestly, it isn't as obscure as people tend to think. The community just tends to keep to itself, therefor most non-roleplayers have no idea of what goes on - or that it goes on period.

It is quite active, though. I'd recommend taking a look at the community's site if you're serious about wanting to learn more.

http://www.ffxiv-roleplayers.com/