Text this: A Comparative Study of Convolutional Neural Network and Transformer Architectures for Drone Detection in Thermal Images