The number of people who left cities is a remarkably small part of the US population and many of them just left high-cost cities for other lower-cost cities.
The steady increase in % of the US population who live in cities (83% in 2023 up from 70% in 2022) [https://www.macrotrends.net/countries/USA/united-states/urba...] suggests that yes, Americans do in fact want to live in cities.