I'm so old I still have a multi-purpose personal server instead of separate VPS/containers for everything.
Honestly, I suspect most people use either traditional hosting or a personal server for their sites. The separate containers on VPS providers thing is significantly overrepresented on sites like Hacker News, and likely counts for why many scripts (not just Ghost) haven't quite cracked the mainstream yet.