No, if you want to roleplay you will roleplay a goblin with all its advantages and disadvantages because that makes him a goblin. He is incredibly wise for his people, which is also what makes him PC material exceptional, but he can't match a wise human (yet he is still more wise than 90% of humans he will meet and certainly more wise than nearly all goblins). So no, it doesn't improve role playing at all. It just allows powergamers to pretend that they are role playing.
It affects roleplaying in that (some) people are less likely to choose that race if it is suboptimal for that class. I think that the role-playing disadvantage for a goblin should more be that the world probably hates you, less that you just can't be as wise as other races can be.
Regardless if race ASIs are good or bad or neutral for roleplaying, it is a common house rule to allow replacement ASIs. Tasha's just made this explicitly allowed by the rules (assuming of course your DM allows Tasha's)
