Making a field greater than the limit unique
A realistic email limit could have a length of 64
email addresses are never utf8, only ANSI
innodb_large_prefix can give you a bigger index.
generated column
with a HASH as a unique index is just as good, like:

ALTER TABLE members ADD email_hash VARBINARY(56) AS (SHA2(email, 224)) UNIQUE KEY