The role of the tachyonic instability in Horndeski gravity