Charge transfer vibronic excitons in ferroelectric oxides: experiment and theory