Do you think they will be able to create some type of medicine which is going to be effective against the virus any time soon, because we all see that the vaccines maybe won't be the key to beating the virus?

Possible? Probably.
Profitable? Absolutely no.
Why bother with a pill which is going to be used by only the sick people when you can vaccine the entire population every month? Financially vaccines make more sense so nobody is talking about pills.