MongoDB Aggregation Framework versus Pandas using PyMongo?

Hard to predict required memory without know the dataset size, the queries and doing a full working set calculation. If you are using Atlas it is relatively easy to try out different configurations and see what memory configuration works.