I am so confused my head hurts...lol

Looking at this flight


Singapore Airlines
Flight 1037
Departs: Mon Sep 10 9:15am
Vancouver - Vancouver International (YVR) Arrives: Mon Sep 10 11:30am
San Francisco - San Francisco International (SFO)
Operated by: AIR CANADA
Singapore Airlines
Flight 15
Departs: Mon Sep 10 2:10pm
San Francisco - San Francisco International (SFO) Arrives: Seoul - Inchon International Airport (ICN)
No plane change
Singapore Airlines
Flight 15
Departs: Seoul - Inchon International Airport (ICN)
No plane change Arrives: Wed Sep 12 0:50am
Singapore - Changi (SIN)

I'm trying to figure out the fare class of a particular SQ flight. Found a good fare, but of course the booking website does not list the fare class..so after doing some research someone recommended http://matrix.itasoftware.com/. is that the only way to find the fare class on these type of websites??

Getting that info for the SFO to ICN flight on ITA, the fare shows as Q.
On AC aeroplan all the booking classes show as gaining 100%
R, F, P, A, Z, C, J, D, S, Y, B, E, M, H, W, L, K, U 100% of miles

but there is no Q fare??!!

I guess I should not even care, as all flights with SQ will gain me 100% miles with AC aeroplan....is that correct?

Further, if I want to book an upgrade on that SQ flight with my aeroplan points, from what I understand I have to book a SQ ticket in Y or B fares (and also S fares with SQ) and then request the upgrade for 25,000 miles in my case from SFO to ICN. (also since the above shows as no plane change, the upgrade would be all the way to SIN..or no?)

So I get upgraded automatically on SQ, is there a waiting period or waitlist or how exactly does it work?

I know that it is a lot of info and questions, but I would really appreciate anyone's help