It is still used on directories. On executable files it is typically
ignored.
Ignored for executables on many systems (Linux being the example it's
easy for me to check). Used on directories (again in some systems),
but for a different purpose. From the man page for chmod on my Linux
box:
On older Unix systems, the sticky bit caused executable
files to be hoarded in swap space. This feature is not useful
on modern VM systems, and the Linux kernel ignores the
sticky bit on files. Other kernels may use the sticky bit
on files for system-defined purposes. On some systems,
only the superuser can set the sticky bit on files.
When the sticky bit is set on a directory, files in that
directory may be unlinked or renamed only by root or their
owner. Without the sticky bit, anyone able to write to
the directory can delete or rename files. The sticky bit
is commonly found on directories, such as /tmp, that are
world-writable.