You're referring to source available licenses. These range from the nearly open like Mongo or ElasticSearch to the almost totally closed like Windows or Solaris.

They're not inherently bad licenses but they aren't open source.