I've personally been flying for just over three years now and have learned a lot about drones. When I look at the work done by these big drones, I think about all the more possibilities I'd have being able to operate a larger aircraft as a team.
The Mavic 2 has to be my favorite drone solely because of how convenient it is. A lot of my work over the past three years has been shot with a Mavic just because it was a drone I could always have on me. However, when I compare this little beast to a larger aircraft like the Inspire 2, I watch the quality get crushed by the bigger sensor on my X5S. A Mavic is made for a single person to fly and makes a perfect tool for scouting, personal work and small jobs. An aircraft like the Inspire 2 was built for one or two people to fly by allowing options for the pilot to focus on the flight while the camera operator focuses on the shot.
When I bought my Inspire 2 a few years ago, I knew that dual operator would be something I had to get into. After learning how the drone flew single operator, I was ready to find another person to help me out with flying. Though I fly single operator a lot, practicing dual operator and getting familiar communicating with my team has helped me significantly when it comes to certain work. At the level Palmer is operating on, single operator is more than likely out of the picture because of how technically advanced these drones, cameras, and lenses can be.
When it comes to big drones versus little drones, it all comes down to what we are filming. You more than likely won't just see somebody flying an Alta 8 and RED but you will find plenty of people with a Mavic. The big drones are for larger scale work where the focus is on the shot the director wants to get. These drones can hold up to 20+ lbs while the camera and lenses can be swapped out and the drone operators can control specific things like focus, zoom, and aperture as they desire. With a Mavic, you wont have those pleasures but this is really a drone for anyone/anything.
For more on Trent Palmer, check out his YouTube.