What (I think) we need is a regulated system where every drone uses a standard transponder and negotiates airspace either with a controller (e.g. IFR) or other aircraft (e.g. VFR). The future is not everyone flying drones with proprietary AI collision avoidance. One existing product in this space is FLARM which is used by a lot of glider pilots and light aircraft, they also make a UAV variant: https://flarm.com/products/powerflarm/uav/
Autonomous drones themselves exist, are inexpensive, and can be set to fly a survey pattern based on a number of pre-selected GPS waypoints. Ardupilot will do this. The data is used for mapping at a much higher level of data than online maps. Think agri, ecology, general site surveying, etc.
That said, drones are not ideal for replacing aircraft in the large scale mapping. The flight time is poor. An aircraft modified for surveying can cover hundreds of square kilometres a day. A consumer drone with an hour's flight time (good luck) is going to struggle to compete.
Collision avoidance at the local level (e.g. are you going to hit a wall) is a different issue, and that can be solved by standard depth sensors.