I literally ran into this myself recently replacing the SSD inside an old Chromebox.
I was literally unaware that it was an entirely different spec based on keying.
Further, it seems I can’t find any reputable companies that make a SATA M.2 SSD in the 2242 size anymore. I can only find old Western Digitals that are more than double the cost of an equivalent NVMe simply because WD doesn’t actually make SATA M.2s in that size anymore.
The only companies that make them in that size are all weird bogus never-heard-of-them-and-the-reviews-are-terrible.