Q: Does WP RSS Aggregator work with JSON feeds?

The simple answer is "no".

WP RSS Aggregator can only import RSS feeds, not JSON feeds.