God is often termed a rock in scripture. It is a symbol of strength and stabilityThere is no mention of a spiritual rock that was following the Israelites around in the desert and even if there was it was spiritual in reference to the rock Moses struck and water gushed forth. That would render your understanding as spiritual, as the Scripture states, and not literal. It's all prophetic foreshadowing of Jesus being pierced with water gushing forth.
The pre-incarnate Christ however is stated to have followed the Israelites in the desert. This is a reference to the Angel of the Lord who is called God and YHWH and now identified as Christ
No it does not1 John 1:1-2 refers to the Word as an it, a thing. John 1's poem about the Word is personification of a non-person thing. This is precedented since in the OT there isn't an actual person named the Word, but there is plenty of personification of God's words. There is plenty of personification of many things in Scripture that, if taken literal, wouldn't really make any sense. Do you also say the church is literally the Bride of Christ? How is that when you aren't a female and men marrying other men is a sin in Scripture? See, we can go too far with an idea and then it doesn't make sense anymore.
1 John 1:1–2 (KJV 1900) — 1 THAT which was from the beginning, which we have heard, which we have seen with our eyes, which we have looked upon, and our hands have handled, of the Word of life; 2 (For the life was manifested, and we have seen it, and bear witness, and shew unto you that eternal life, which was with the Father, and was manifested unto us
1John 1:1 speaks of that which they have heard, seen and handled of the word of life. This was the man Jesus Christ who is not an it
and The pronoun It does not appear in the Greek text