Air intake broken... is it fixable
 

https://www.rx8club.com/members/imn2...hose-38103.jpg

So can I just super glue this piece back on or should I try and find a new piece to insert the air hose into?

You can try super gluing it temporarily, but you can pick up a replacement elbow for cheap....they commonly break:

https://www.mazdatrix.com/8intake.htm

(bottom of the page)

got one at napa for 3.77 doesn't look the same but fits like a glove :)