Is it weird that i feel more comfortable in asking my dad to buy me tampons?

It's only as weird as you make it. I think it is much more strange that you didn't just get them yourself. Also, it is weird that he thought it was weird. I mean, he is a grown man, he needs to just "grow a pair" and take care of his daughter.