According to the RIAA, It doesn't look good for physical media

For my absolute favorite albums, or just albums that I think set a good mood, I do vinyl. For albums that I really enjoy, or maybe just that have a decent number of tracks that I really like, I buy used to CDs and then rip them into FLAC. Everything else I stream. Streaming is great, but listening to music that you actually own I think helps you to digest music in a slower and more thoughtful way.

This statement is misleading.
The statistic of dollar amount of LP’s exceeding CD can be explained by higher pricing of LP’s per unit. Vinyl can be more than 2x the price of a CD.

How is it misleading? I just stated what each format shipped in units and dollars.

It is inevitable that units of LP will overtake CD.

Yes it is, maybe by the end of this year. But that percentage change year over year for vinyl units shipped isn’t too far from going negative.

Amount of CDs sold most likely doesn’t include used CDs sale.

No, it doesn’t. Nor does the LP number. These are units shipped by the record labels during the first half of 2020.

My Discogs collection value is going up faster than my 401k.

Might be a good time to sell if you want that money. I think there will be more collections going up for sale as more boomers depart. In the last 20 years I've watched bubbles inflate and burst in baseball cards, tech stocks and real estate. I'm sure there have been many others.

My 53 still sealed dbx discs I paid $2 each for in 1990 are up to over $200 now.

I inherited 4000 LPs from my folks, 1/2 still sealed. None of my older brothers and sisters wanted them. Until now. Nope! Not getting them!

My mother worked at Columbia Records 1955-1967. 4000 pristine copies, all labels. Columbia was the largest presser in the world then.

One thing with new vinyl is usually there is also a hi-rez digital download included. Pretty much all I “buy” these days is vinyl. Old and new. I use my NAS, Spotify, Pandora, and Amazon Music for various other reasons. I rarely listen to anything streaming “critically”. Normally, any of the above are played when doing things around the house, in the car, or at the office. Vinyl is pretty much my “thing” these days.Occasionally, I play a CD, but since most of them are on my NAS as hi-rez files, I usually just play that instead.