Note in the linked post there are two different scenarios, one is for only the background to be transparent and the other is for everything in the window to be transparent. Make sure you use the correct version.
I personally feel like it's a gimmick without a lot use, but if anyone can provide a proper implementation and API design, then I would certainly consider add it to SFML.