It is just as affordable as it has ever been if you want it to be...actually in many ways even more affordable with the packages that include drink/food. Smaller portions, but that is all some people need and sometimes a smaller portion for your kid to eat half of anyway. People looking for affordable sit in the terrace or maybe the bleacher, that really isn't any more expensive these days. The only way it is more expensive is if you are picky as all get-up, must sit in a certain section, must go on a certain specific day of the week against a specific team in a specific month.
There are still a ridiculous amount of games, some on weekends, some in the summer, and some on holidays where tickets are less than $15 (maybe even $10).
I think the reduction of people going to games is a bit overblown. The start of this argument dates back to 2017 or so (72.7mil), where it then tumbled to 68.5mil before COVID. Things hit a concerning level in 2022 when they were still only drawing 64.6mil post COVID. However, that number spiked to a staggering 70.7mil in 2023. If you want to specifically look at the Brewers, they drew nearly identical fans to the park in 2017 and 2023. However, they ranked worse overall in 2023 (#15 versus #10).
So, between 2017 and 2023 there is hardly that much of a decline in fans going out to the park. You could reduce that gap even more if you consider the clownery in Oakland effecting it a solid half million. It remains to be seen if the staggering jump in 2023 will stick. If it does (or even improves) I really don't think MLB has much of an attendance issue on their hands. Even if it declines slightly, you could probably just attribute that to economic times and I bet most sports will see struggles too.