It's so sad to c My Photo Stream to be gone end of this month (July 2023).

Let's say we use iCloud Photos as the only solution.

My query is:
What happens when the iCloud storage is full? Will the older photos/videos be replaced with the new ones?