Is it possible to convert 4-pin floppy to SATA power?
Yes, it is legit. All of these adapters use +5V or +12V pins with some earthing.
The adapter what you want to buy does only the physical conversion, because no electrical conversion is needed.
You could even convert them manually, by simply cutting a SATA power extension cable and soldering (or using terminal blocks).