I think it's partially the isekai-like fantasy of being a bullied, neglected kid and finding you're actually really cool and famous in a secret world filled with magic. That and the Houses giving kids a way to identify with a personality-based category, which they love to do (see also: Homestuck).