Both sentences are grammatically correct. But very few people in America would say "The weather is horrid today". Horrid sounds too antiquated, too proper to American ears.
Though, I admit, I use it frequently. I think that's because I read too many old books.