The market can't be bullish just because the supply is low.Something must trigger an increase in the demand.
Demand isn't determined by the supply.Demand is determined by the future expectations/greed and a bunch of short term factors,like bullish news,FUD and panic selling.
The Bitcoin supply is limited by all the BTC that were lost during the years and the army of HODLers,who are expecting a better price to sell.Bitcoin mining isn't a big factor,which can determine the BTC supply.It used to be years ago,but now,it doesn't matter that much.

Bitcoin isn't an essential stuff so we can't bank on the fact that the demand will always be consistent not to mention that without this red days in the market, I think that we will eventually make the prices so premium that it's going to be difficult for newbies to get in.

with 90% is mined meaning only 10% left. then 'supply/demand' basic math would be 10x of the price of when the first coin was mined.
because there is 10X less supply left to be produced.

the price however is over 400,000x the price of 2009. .. so i think the laws of supply demand are working.

i wont go into the finer details that the market price, is only established by the current price of one market order lines offering of under 1btc at any one time. and not the entire coins ever made.
nor that the supply/demand that affects the market price of the top orderline is limited to only the colection of orderlines of what exchanges have on deposit, rather than the entire coins created.
put simply market prices are established by the supply of the market(exchange) not by the entire networks coins

but just be thankful that the price is over 400,000x more then the price in 2009

Because despite the sensationalist title nothing really extraordinary will happen.
There are 900 coins mined each day and there will be 900 after this week and after this month passes till the next halving, there is nothing amazing that will make the supply ration change radically, the only thing that can change is demand and that once can't be anticipated by anybody.

Oh, and to understand how ridiculously low the change is, exactly one year ago, 88.38% of the coins were mined.

Also, from a different perspective, there are 900 coins mined each day at a value of $45 million, one year ago the daily reward was $17 million, and five years ago just $ 1.5 million so in fiat terms, the daily offer has increased 3 times in the last year.

I agree with you that this would be your initial thought, but I think Bitcoin is still in the phase of getting going and this lack of supply will eventually be realized by a surge in demand as time goes on. So I think personally we are still just a bit early on the game.

Zoom out when you look at the charts and you will see that markets are very bullish long term, but there are many factors that affect price and it's not just programed Bitcoin supply.
In 2019 it was 85% Bitcoin mined that is not such a big difference, and we have around 100 years until last bitcoin is mined, so just relax and watch the show.

Next Bitcoin halving should happen in Q1 of 2024 and that is one more important indicator that is affecting the price, but even without that we have crazy fiat money printing machine, so I am not worried at all about current BTC price.

That's one way of addressing the issue of having problems on where to get your money for investment but the problem is that even if they were to abandon expenditure on leisure and luxury stuff, it might not be enough to make a significant amount of bitcoin when you're buying it again.