The Pride of Texas Super Shot Drop Tower was an exciting ride for fairgoers