In the UK this lot
https://www.flyicarus.co.uk have been in the arial photo/video business for years . They have helicopter pilots as well as drone operators. They do the approved courses for the UK PfCO training and examination for commercial opperations. They are very good at it.
Over the last year they have started doing more Business orientated courses.
When I spoke to them recently they said that 80%+ of those who did their commercial course did not renew their CAA registration the following year. (CAA is UK version of FAA and annual registration is about $300 a year) The problem was most who went into drone photo/video had no idea how to run a business much less make money at it.
As noted above it is a BUSINESS that just happens to be in the drone sector.
You have to be able to run a business.
I would warn against jumping into it.
The reason is about 15 years ago I saw what happened to photography. Every man and his dog got a digital camera and broadband internet. Suddenly "everyone" was a photojournalist or a "citizen journalist" . the bottom dropped out of the market. Prices plummeted. no one cound lake a living bar a few with good networks, ruthless business sense and well just being ruthless.
The same happened in the wedding market. People doing it as a hobby or semi-pro undercut everyone else. The market was flooded and often a family friend did it for free. Many/most averagely good wedding photo outfits had a very hard time or closed.
In Corporate photography the same thing happened. The photo enthusiast in the office now takes the photos for the web site and desktop published PDF catalogue.
You are looking to go into aerial photography.... as is everyone and his dog. The Semi-pros and hobbyists will flood the market and drop the prices. If companies have a member of staff with a drone they may use them (for overtime payment + a free lunch)
In ALL these cases a few very good people survive at the top, those in niche markets survive. Those who are in an isolated area geographically will survive ie the only game in town. The majority will not make any money at it. Unless they are ruthless and very very good at business.
Keep the day job.
Only quit the day job when it is in the way of your drone work and the drone work is generating more than enough to live on. May be not as much as the day job but make sure you are established and it is REAL money in the bank not something that "will" happen next month. As any of the pro's on here will tell you unless it has happened (and then you have to chase payment) there is no guarantee ot will happen.
But that's business.
I have been running one nealry two decades.