There's probably a good use-case for MongoDB, but what I saw in practice was that it was an excuse for poor developers to avoid learning some dialect of SQL.
It's the same story with ORMs. You will eventually need to learn to write SQL. For some reason developers try to avoid this almost as much as possible. Maybe more than other technologies.
At some point, you are going to want to query data. And eventually you will reinvent what RDBMSs do out of the box, because they're purpose built for this work.
Further, if you need to just dump JSON, an RDBMS is still a better choice for all the reasons above.