Google will now let you automatically delete location and activity history
https://www.cnet.com/news/google-will-now-let-you-automatically-delete-location-and-activity-history/
The option to let Google keep the data until you manually delete it will also remain. You can also still choose to pause Google's web and app activity tracking.
Read: Google clarifies how it tracks you if Location History is turned off