Whenever I try to sign in with my second account on Xbox, why does it tell me to go to...

I think you misunderstood, my Microsoft account still owns my Minecraft account, however, my Xbox account is also linked to my Microsoft account. Whenever I try to login and access my Minecraft account, it automatically signs me into my Xbox, which does not have the Minecraft account. It's still linked to the email, but my Xbox account is stopping me from getting into the account.

The Microsoft account and Xbox account are one and the same...signing into an Xbox account would be the same as signing into a Microsoft account.....if I go into my Microsoft account history on my PC, it shows my Xbox purchases.

That sounds like you have a second Xbox and/or Microsoft account which is linked to the Minecraft account

I was not able to sign into xbox.com with my new account even when I signed out of my other account. When I signed up for xbox live with the 7-day trial it makes you put and email in and that is exactly what I did. And then for some reason, I deleted the
account off my xbox and now whenever I try to redownload it xbox live is trying to tell me the account doesn't exist or that the email is not valid because it keeps giving me the message, "This email address isn't linked to a Microsoft account. Make sure it's
correct, then enter it again." (I know how to download profiles because I do it at my friends everytime I go over there) I don't know why this has to happen when I'm just trying to have fun with a new account.

I'm playing NON-Ranked. I know those don't work. But here is what happens

-click matchmaking

-its all good to go

-add second player (guest)

-before we fully sign it it says we need a profile with xbox live on it.\

-signs me out

I can play online alone, I've been doing that today, but whenever i try and add a guest (using the guest live account) it tells me i can't.

Hello,

I had this exact issue myself, Whenever it tells me to view my network diagnostics i press "Retry" or "Horizon solo", Then once i am in Solo i go back to "Horizon life". If that does not work try to re-install the game. Then if that does not fix your problem unplug your router for 30 seconds and plug it back in.

I think you misunderstood, my Microsoft account still owns my Minecraft account, however, my Xbox account is also linked to my Microsoft account. Whenever I try to login and access my Minecraft account, it automatically signs me into my Xbox, which does not have the Minecraft account. It's still linked to the email, but my Xbox account is stopping me from getting into the account.