I made this exact same comparison when explaining Taylor Swift's vinyl sales to someone the other day.
The bright side is that these crazes don't tend to last. The bottom has completely fallen out of the (American) comic book market, and it's probably only a matter of time before the same happens, if in slightly less dramatic fashion, to vinyl. I don't foresee CDs ever outselling vinyl again, but these vinyls with five or six different variant colors, a limited picture disc, several different covers and so on released along with the standard edition are probably not going to be a thing clear on into the future. There's only so many times you can sell five albums to someone who probably doesn't even own a turntable and just wants to flex on Instagram. Imagine these people who bought five copies of Taylor Swift's Midnights and now have them hanging on their wall. What are they gonna do when the next Taylor Swift album comes out? And the next one? What, are they gonna end up with Taylor Swift vinyls covering all the walls in their apartment? I see this variant trend lasting 2, maybe 3 more years before dying out completely.
Already some of the smaller labels I follow are having trouble selling off their limited variants as opposed to just the standard black editions (usually these sized labels make only one, maybe two variants of their releases, if any). At the same time, some of these labels are running into production backlogs of several months. I get how annoying that can be, and a lot of it is the fault of these larger artists and their 15 variant editions, but hopefully at some point these labels will wisen up and knock this comic book variant cover bullshit off. It's not like the people who are actually interested in the music will refuse to buy the records if they only come in a regular black vinyl release.