There are NoSQL databases out there that specialize in doing stuff like: serving high volume JSON document reads (CosmosDB / MongoDB), data warehousing (Snowflake, Azure Synapse), graph querying, website caching (Redis, Memcached), etc.
They perform at much higher level than SQL Server, for basically three reasons: they store the data in the format in which it is queried, they leverage distributed nodes, and they don't even try implement all the rules surrounding transactional isolation.
Where I work, we leverage SQL Server, Azure SQL, CosmosDB, Redis, Snowflake more recently - and maybe something else I'm not even aware of.
So, I'm on the DBA team, and there may actually be database platforms in use that I'm not aware of. Why? Because some of these NoSQL databases are really just tools for staging data that: transforming data for import, middle tier caching for web and mobile applications, or data extracted from SQL Server for the purpose of analytics and data science. So, it's outside the scope of database administration. You don't really need to know Jack about all the data processing trades.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho