Some global websites make money (like Facebook), others burn money (like Twitter).

Some niche websites hardly get visitors, others get a lot, depending on the niche and the competitors. But for them also: visitors don't automatically mean money.

The best niche to choose is one that doesn't yet exist, so you have no competitors, and is interesting for a lot of people, so you get a lot of visitors.

Kees