Ooh,
Maeve Titania. I like it!
As a first name,
Titania is a no-go; tit,
Titanic, even the size implications of Titan would make it hell to grow up with. As a middle name, I think it's fun and very usable. I wouldn't mind sharing my name with the queen of the fairies, as long as I didn't have to go by it all the time.