Hopefully he shows up again somewhere in the MCU. Ghost Rider is perhaps the visually coolest character in comics. I'm sure they can find somewhere to stick him.
Though I wonder if they'll just use a different Ghost Rider and sort of seperate themselves from the TV side of things. Not that I think they need to.