According to Apple[0] it is only after the specific activities of: Outdoor Walk, Outdoor Run, and Hiking. Which explains why my estimated VO2 max goes down significantly in the winter months when I'm mainly doing cardio indoors and only taking leisurely walks with the dog outdoors.
[0] https://support.apple.com/en-us/108790#:~:text=Apple%20Watch....