They'll keep dying off as EVs rise in popularity. There will always be a small niche where it will be available. I think cars like the Miata, Mustang, and 911 will hold onto it. Maybe even the Wrangler and Bronco. BMW seems to be the last one of the German big 3 holding out with a stick shift in the M2 and upcoming M3, but I'm not sure how long that will last.
In general the market is shunning what we deem "driver's cars." With crossovers/SUVs and pickups rising in popularity, the world becoming increasingly tech dominated, increasing safety standards, politicians trying to legislate ICE cars out of existence, and the EV circlejerk these cars will be relegated to an insignificant portion of the market. Lightweight, manual transmission, and tight feedback-providing steering are becoming a thing of the past.