I've seen these later square Sharp Boomers but they seemed to be mostly JDM (Japanese Domestic Market) Models While noodling around the internet I found this really neat version, the Sharp QT-93CV with a built in LCD TV. CDV was a short lived CD format, 5 minutes of video and 20 minutes of audio, I'm not sure what replaced it if anything did before mpeg and avi kind of took over. This awesome unit had: Twin Cam! 7w + 7W + 12w (sub?) Remote TV Tuner 23 Track Music Calender This retailed for around $1364.00 USD back in 1989! Anybody own one of these?
Video CD replaced CDV https://en.wikipedia.org/wiki/Video_CD . I had a Philips CDi player with the Digital Video cartridge and was surprised how well it worked (about as good as VHS). In the far East it was very popular maybe due to the availability of cheap CD burners. It is reasonably easy to find old Video CDS here https://www.ebay.co.uk/itm/287198996905 In contrast searching for CD Video drew a blank. It doesn't help that the name is so generic.
The generic names always kill me when searching but it's getting better everyday. The late 80's until early 90's is kind of the lost format era, so much was hitting us as the latest and greatest that I have a hard time with dates unlike VHS/Beta, CD, Tape, Etc milestones in the 80's and even some of the digital milestones of the 2000's. I think the game consoles also had the same issues, everyone was jumping in after Nintendo revived the industry but most were forgotten.
Looking through hundreds of listings I eventually found about five CD Video discs for sale on eBay This was the cheapest https://www.ebay.co.uk/itm/147066887645 It turns out the video track is actually analogue so only specialist equipment like the the Sharp Boombox can play it. I wasn't surprised to find that Techmoan had produced a Video on it complete with an explanatory title You are right that back in the past lots of formats were tried but few stayed around for long. Looking at the "Now" album listings I was surprised to see that one was released on UMD. https://www.ebay.co.uk/itm/296535124412 You would have to be a real enthusiast to pay £120. The same thing on DVD can be easily bought for under £4.
It's like stereo microcassette, you can find the players but good luck finding metal cassette tapes. I'm not finding any discs on USA Ebay and Sharp made it really fun by having a model here called the QT-93. While it looks late 80's cheap, it does have logic controls! It's has to be one of a few like that, most were either plasticy or still heavy duty looking at that time.