I mean I hear about it all the time, but when I check the actual user base, no one is practically using it.

Case in point is Godot. Indie devs talk about it like it's the second coming of Christ, how Unity is done and over, then you look at the stats and barely anyone relevant is using it.
Open source software seems to always just be used by the loud minority.
How so?