PCIe SATA adapters will likely be around forever. They may be problematic to boot from, but A) I'm sure your OS isn't on a spinning disk, and B) by the time PCIe SATA adapters disappear the entire concept of a PC will be an outlawed or legacy retro thing anyway.
Agreed... although it would be nice to find easier support for older formats, they do stick around for a while. I've got a 3.5" USB floppy in my garage that's been sitting for over a decade now, and even then it was long after CD/BR and thumb drives were the norm.