Hi Paul,
This is a tough one.
In my eye, Here's the way the  profile world has evolved.

When I first got my Profile Prism (PP), I was buying glossy paper cheaply from Sams and Office Depot. It was a must to profile that paper...
Since that time, the picture changed.
Now every printer worth a hoot supplies profiles with the driver install that cover all of their paper types...
Over the years using an HP 2000 Epsons  1280, 1800, R2000, I made my own profiles because I could actually beat the print quality of the profiles Epson provided.  (I think that the insurgence of Pigment inks was giving them fits)
BUT, lately, they have improved the quality.

So I lost my R 2000, and decided to go with a Canon Pro-100. It came with a ton of profiles for every one of Canon's papers.
I still made a few PP profiles to cover my left over Epson paper being used on a Canon printer with Canon DYE ink.
This is within the last 9 months.

The last item on the list has to be the profiles supplied for most decent printers by the paper manufacturers.... Ilford, Red River, Hanna's Mule, just to name a few. .. and they are well done so you will be pleased with your prints on their paper, and reorder.

So, let's answer your question. No, not dead. Going to be upgraded, doubtful. Still available and still useful, yes!

Many people have purchased profiling kits that used to cost over 1000 dollars which use a Spectrophotometer which now cost less than 300 dollars.
Some more thoughts?

Fred